Question

4
Replies
736
Views
pramodk8 Member since 2015 18 posts
Accenture
Posted: 4 years ago
Last activity: 4 years 5 months ago
Closed

ORA-01460: unimplemented or unreasonable conversion requested   | SQL Code: 1460 | SQL State: 72000 while sending data in mail

Hi ,

i am getting the below error while calling OOTB SendEmailNotificationWithAttachments


** Caught com.pega.pegarules.pub.PRRuntimeException: caught DatabaseException while trying to open conclusion Property!UESDBBQACAGIAHGDPKGAAAAAAAAAAAAAAAATAAAAW0NVBNRLBNRFVHLWZXNDLNHTBLWWY27BMBBFF0XGTRDOZBEEHEUSKNAZBOGLDEUTI4SIHWI5SUS/70IKHDSR3JE5MWTEO7XNHHSGZU1RTFYMIWRVCNARR1KGTNQL3AFG33DFV9CSIYICESY7KNGRIRVZBNBHGMJGTS4WREKSP3MEZQVWXNZX4EGPFBAC6W848FRIJ3EAFRLEX3HPHYLDFXZ7SO3MDKRRGMY+TLQ8CFRODCTUB2OXVTCEFNM/ZMDLAPJ4RKTUT: There was a problem getting a list: code: 1460 SQLState: 72000 Message: ORA-01460: unimplemented or unreasonable conversion requested

DatabaseException caused by prior exception: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

i have  a scenario like get the data from WorkattachFileclass and send that data in mail.

i follow the steps in activity

1.) get the data from WorkAttachFile (pyAttachStream contains actual data)

2) set the value of  pyAttachStream property of WorkAttach-File class to pyReference property of  Data-EmailAttachments class

3) open the Data-EmailAccount class

4) Call the OOTB activity SendEmailNotificationWithAttachments by passing Data-EmailAttachments page as parameter to SendEmailNotificationWithAttachments

Pls give me suggestions/ideas to fix this issue its very urgent

Thanks For help.

Thanks

Pramod

Pega Customer Service Low-Code App Development Case Management Security Data Integration System Administration Reporting Decision Management Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn