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

 Karthik Kummera (Karthik K) Pegasystems Inc. Senior Demo Engineer, Support
Pegasystems Inc.
IN
Karthik K Member since 2016 36 posts
Pegasystems Inc.
Posted: Dec 18, 2017
Last activity: Dec 20, 2017
Posted: 18 Dec 2017 12:29 EST
Last activity: 20 Dec 2017 4:26 EST
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.

To see attachments, please log in.
Data Integration

  • Piyush Tiwari
Posted: 6 years ago
Posted: 18 Dec 2017 12:57 EST
Arun Kumar Mahanty (Arun_Mahanty) Pegasystems Inc. Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hello Karthik,

As you have executed the delete query  records would have been removed from the table.

Still from the class KART-PocPeAPP-Work-AccountCreation you can create new instances ,let us know if you have any other specific questions .

Thanks,

Arun

 

 

 

To see attachments, please log in.
Posted: 6 years ago
Posted: 18 Dec 2017 13:25 EST
Karthik Kummera (Karthik K) Pegasystems Inc. Senior Demo Engineer, Support
Pegasystems Inc.
IN

Thanks Arun.

But, Obj-Browse is not working (new instances are created). Please, find the screenshots.

I checked, Obj-Open is working. But, Obj-Browse is not.

Show More

Thanks Arun.

But, Obj-Browse is not working (new instances are created). Please, find the screenshots.

I checked, Obj-Open is working. But, Obj-Browse is not.

<pagedata>
<pxTotalResultCount>0</pxTotalResultCount>
<pxPageCount>0</pxPageCount>
<pxMore>false</pxMore>
<pxResultCount>0</pxResultCount>
<pyMaxRecords>10000</pyMaxRecords>
<pxSQLStatementPre>
SELECT pzpvstream AS "pzPVStream", pzinskey as "pxInsHandle" from {CLASS:KART-PocPeApp-Work-AccountCreation} WHERE pxObjClass = {pyReportParameters_temp.pyPreparedValues(1)}
</pxSQLStatementPre>
<pxSQLStatementPost>
SELECT pzpvstream AS "pzPVStream", pzinskey as "pxInsHandle" from personaledition.pc_KART_PocPeAPP_Work WHERE pxObjClass = ?
</pxSQLStatementPost>
<pxObjClass>Code-Pega-List</pxObjClass>
<pyObjClass>KART-PocPeApp-Work-AccountCreation</pyObjClass>
<pxQueryTimeStamp>20171218T181758.820 GMT</pxQueryTimeStamp>
<pzStatus>valid</pzStatus>
<pxResults REPEATINGTYPE="PageList"/>
<pzPerformanceSettings REPEATINGTYPE="PropertyList"/>
</pagedata>
--------------------------------------------
DB Trace 
 Database Name   pegadata 
 SQL   SELECT pzpvstream AS "pzPVStream", pzinskey as "pxInsHandle" from personaledition.pc_KART_PocPeAPP_Work WHERE pxObjClass = ?  
 SQL Inserts  <KART-PocPeApp-Work-AccountCreation>
-------------------------------------
 
Properties on Page ResultsPage
 Name   Value 
 pxTotalResultCount   0 
 pxPageCount   0 
 pxMore   false 
 pxResultCount   0 
 pyMaxRecords   10000 
 pxSQLStatementPre   SELECT pzpvstream AS "pzPVStream", pzinskey as "pxInsHandle" from {CLASS:KART-PocPeApp-Work-AccountCreation} WHERE pxObjClass = {pyReportParameters_temp.pyPreparedValues(1)}  
 pxSQLStatementPost   SELECT pzpvstream AS "pzPVStream", pzinskey as "pxInsHandle" from personaledition.pc_KART_PocPeAPP_Work WHERE pxObjClass = ?  
 pxObjClass   Code-Pega-List 
 pyObjClass   KART-PocPeApp-Work-AccountCreation 
 pxQueryTimeStamp   20171218T181758.820 GMT 
 pzStatus   valid 

Show Less
To see attachments, please log in.
Posted: 6 years ago
Posted: 20 Dec 2017 4:26 EST
Ujjwal Kumar Shukla (UjjwalShukla_GCS) PEGA Senior Manager, Technical Support
Pegasystems Inc.
IN

Hi Karthik,

Can you check the value from trace.
something like below

This should help you build the query and check in DB once.

Thanks,
Ujjwal

To see attachments, please log in.
Posted: 6 years ago
Posted: 18 Dec 2017 13:55 EST
Arun Kumar Mahanty (Arun_Mahanty) Pegasystems Inc. Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hello Karthik,

uncheck the getrowkey and try running the usecase .

if it's still not works then let us know the PRPC version and give us the tracer dump .

 

To see attachments, please log in.
Posted: 6 years ago
Posted: 20 Dec 2017 3:03 EST
Karthik Kummera (Karthik K) Pegasystems Inc. Senior Demo Engineer, Support
Pegasystems Inc.
IN

Hi Arun,

I unchecked the rowkey. But, no luck. Obj-Browse is not working. Will provide you the tracer dump.

As you said to uncheck the getrowkey, how it would be influencing the Obj-Browse to function improperly.

I am aware like, if we check the rowkey -- we will be getting the pzinskey of that record.

 

Thanks

Karthik K

To see attachments, please log in.

Related content:

Question

SQL error in ListView: There was a problem getting a list: code: 0 SQLState: 42601 message

Question Solved

Pega 8.7.1 - There was a problem getting a list: code: 0 SQLState: HY008

Question Solved

There was a problem getting a list: code: 6576 SQLState: 65000 Message: ORA-06576: not a valid function or procedure name

Question

Pega 73 Upgrade Error - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PXSAVEDATETIME": invalid identifier

Question

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState:

Question

There was a problem getting a list: code: 1461 SQLState: 72000 Message: ORA-01461: can bind a LONG value only for insert into a LONG column

Discussion

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState: 0A0

Question Solved

getting here was a problem getting a list: code: 22835 SQLState: 99999 while running Report definition

Question Solved

Error while getting the list of checkedout rules: code: -1 SQLState: -1 Message: Database-TableWithNoColumns

Question Solved

Error when trying to use truncate query using RDB-Delete method

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