Question

5
Replies
1417
Views
Karthik K Member since 2016 33 posts
PEGA
Posted: 2 years ago
Last activity: 2 years 10 months ago
Closed

Tried RDB-Delete for Pega Internal Table -- There was a problem getting a list: code: 0 SQLState: 42601 Message: ERROR: syntax error at or near "*" Position: 8

Hi,

Just tried RDB-Delete method for pega internal table, but I could see the below error in tracer:

There was a problem getting a list: code: 0 SQLState: 42601 Message: ERROR: syntax error at or near "*"
  Position: 8 

RDB-Delete query: delete * from {Class:KART-PocPeAPP-Work-AccountCreation }

KART-PocPeAPP-Work-AccountCreation --> I want to delete the workobjects of this class.

I know, its better to use Obj methods for internal tables. But, just want to give a try.

Could you please help. After trying this query, I screwed up :( and even Obj-Browse methods are not working for that class group.

I tried this in Personal Edition and is there any way I can bring it back to normal.

--------------------

Update:

As I identified my foolish mistake "*" in delete query , changed the query to:

delete from {Class:KART-PocPeAPP-Work-AccountCreation } where pxObjClass = 'KART-PocPeAPP-Work-AccountCreation' and tried again. Now, instances/work objects are getting deleted. But, my real worry is -- Obj methods are not working.is there any way I can bring it back to normal.

Could you please help.

Data Integration
Moderation Team has archived post
Share this page LinkedIn