Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Ashwin Vemula (AshwinV3237)
Self
Ashwin Vemula
Self
US
AshwinV3237 Member since 2019 3 posts
Self
Posted: Oct 6, 2015
Last activity: Oct 26, 2015
Posted: 6 Oct 2015 22:29 EDT
Last activity: 26 Oct 2015 12:03 EDT
Closed
Solved

Joining Data-WorkAttachFile is throwing DB Exceptions (SQLCODE=-206, SQLSTATE=42703, DRIVER=3.64.133)

I posted the same error in this PDN link as well:

https://pdn.pega.com/reporting/twenty-seven-commonly-used-join-conditions-for-list-view-and-summary-view-reports#comment…

I joined Data-WorkAttach-File as shown in the above link and got the below error:

** There was a problem getting a list: code: -206 SQLState: 42703 Message: "File.PXOBJCLASS" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.64.133


Also searching for the Hot Fix number as mentioned in this topic: https://pdn.pega.com/forums/prpc/reporting/join-error

To see attachments, please log in.
Reporting

Accepted Solution

Posted: 9 years ago
Posted: 26 Oct 2015 12:03 EDT
Ashwin Vemula (AshwinV3237)
Self
Ashwin Vemula
Self
US

issues is with getContentSpecial Activity - If I remove the getContentSpecial - I was able to save the rule without deleting a attachment authority...

We had a work around to ignore joining 2 classes for this report which is incorrect but we got away with that...Thanks Rajiv.

To see attachments, please log in.

Accepted Solution

Posted: 9 years ago
Posted: 26 Oct 2015 12:03 EDT
Ashwin Vemula (AshwinV3237)
Self
Ashwin Vemula
Self
US

issues is with getContentSpecial Activity - If I remove the getContentSpecial - I was able to save the rule without deleting a attachment authority...

We had a work around to ignore joining 2 classes for this report which is incorrect but we got away with that...Thanks Rajiv.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice