Search

1 to 5 of 5
Sort by

Discussion Reply
Re: CA PPM Tech Tip: How to replace your Jaspersoft Database password so it remains encrypted

I realize this thread is nearly a year old, but since a few commentors and myself had issues updating the password when using configuration password encryption (Failed to Decrypt error when starting the jasper listener) I thought I would post the fix to those issues



Discussion Post
Jasper Request and Target time Join does not work

[usp target time] tim2 on tim2.object id = cr.id and tim2.target tpl = '400003' If I try to do the same (similar) in Jasper Studio I got an error: The multi-part identifier "tgt time mapped cr.ref num" could not be bound The SELECT I used in Jasper Studio is: SELECT casd.tgt time.request ref num, casd.cr.ref num FROM casd.cr LEFT OUTER JOIN casd.tgt time ON casd.tgt time.request ref num = casd.cr.ref num Complete error message: java.sql.SQLException: [DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]AHD12002:Error in QueryHandler Servicedesk-1729890684-1 in method fetch response: AHD04199:An unexpected error occurred


Discussion Reply
RE: Jasper Request and Target time Join does not work

But as I'm not a Jasper specialist, I'll leave it to you and others to work out the exact kink: https://radacad.com/fixing-the-error-the-multi-part-identifier-could-not-be-bound-in-join-statements - - - - <Snip!> the reason is that SalesOrderHeader (SH) table is hidden from the third part of the join. and if you want to apply joining condition it will throw the error


Discussion Thread 2
Jasper Request and Target time Join does not work

Focus Search - [usp_target_time] tim2 on tim2.object_id = cr.id and tim2.target_tpl = '400003' If I try to do the same (similar) in Jasper Studio I got an error: The multi-part identifier "tgt_time_mapped_cr.ref_num" could not be bound The SELECT I used in Jasper Studio is: SELECT casd.tgt_time.request_ref_num, casd.cr.ref_num FROM casd.cr LEFT OUTER JOIN casd.tgt_time ON casd.tgt_time.request_ref_num = casd.cr.ref_num Complete error message: java.sql.SQLException: [DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]AHD12002:Error in QueryHandler Servicedesk-1729890684-1 in method fetch_response: AHD04199:An unexpected error occurred