SAP SAC 5.3 SP11 - New Feature, Delete All Requests

[Former Member]

Hello All,

I am very interested in this "New Feature" for our test system listed in note 1168508.

"NEW FEATURE - With this support pack, a new feature is delivered to

allow a user to delete ALL REQUESTS in CUP. This feature is

specifically designed to be used in a non-productive environment to

delete test data so that custom fields and workflows can be changed

or removed."

My question is how can I utilize this feature? I see no way of "deleting all requests".

[Former Member · Accepted solution]

Hello IanS,

Please raise OSS Message for SAP, They will provide you delete script. With the help this script you can delete all the requests from CUP.

They have also scripts to delete the entire Configuration as well and after that you can once again configure the CUP from scrape

Thanks,

Jagat

[Former Member · Accepted solution]

Obtaining a script from SAP doesn't seem like a "new feature". So this is not truely an option in the application itself?

[Former Member · Accepted solution]

Hi,

This feature is there in CUP, I am on SP11 and I have used it a few times now.(And it can be very useful!)

Did you import the latest files for SP11? IS the upgrade option avalaible to you in CUP?

If it is not avalaible under requests,I am almost certain, its one of the two.

.

Thanks,

Chinmaya

Edited by: chinmaya prakash on Dec 17, 2010 3:25 PM

[Former Member · Accepted solution]

We just upgraded to SP12.1 Build (01072110)

I do not see an option under requests but I will double check.

I do have the "Upgrade" option. This is the first upgrade I have gone through. Our BASIS team upgraded the application. Were there scripts that were run through this tab to get it to 12.1?

Edited by: IanS on Dec 17, 2010 4:41 PM

FIXED I re-added all actions to the AEADMIN role in UME and now I see the new options.

Edited by: IanS on Dec 17, 2010 4:52 PM

[Former Member · Accepted solution]

Ok so I now have this option. I have tried to run the job several times and it fails each time. I have several cancelled requests in the system. Here are the logs if anyone has any ideas. I am thinking a delete script (as mentioned above) is my only option at this point.

2010-12-17 13:48:05,974 [Thread-1060] ERROR Error in running Delete All Requests BGJob

com.virsa.ae.dao.DAOException: SqlException occured while deleting the requests

at com.virsa.ae.dao.sqlj.DeleteAllRequestsDAO.deleteAllRequests(DeleteAllRequestsDAO.sqlj:138)

at com.virsa.ae.service.deleteallrequests.DeleteAllRequestsBGJob.execute(DeleteAllRequestsBGJob.java:55)

at com.virsa.ae.backgroundjobs.BackgroundTask.run(BackgroundTask.java:62)

at java.util.TimerThread.mainLoop(Timer.java:461)

at java.util.TimerThread.run(Timer.java:408)

Caused by:

com.ibm.db2.jcc.a.nn: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=SAPDA4DB;DELETE;SAPDA4DB.VT_AE_RQD_WPCLD_AR, DRIVER=3.52.95

at com.ibm.db2.jcc.a.ad.a(ad.java:666)

at com.ibm.db2.jcc.a.ad.a(ad.java:60)

at com.ibm.db2.jcc.a.ad.a(ad.java:127)

at com.ibm.db2.jcc.a.rl.c(rl.java:2424)

at com.ibm.db2.jcc.a.rl.d(rl.java:2401)

at com.ibm.db2.jcc.a.rl.a(rl.java:1902)

at com.ibm.db2.jcc.t4.db.g(db.java:138)

at com.ibm.db2.jcc.t4.db.a(db.java:38)

at com.ibm.db2.jcc.t4.t.a(t.java:32)

at com.ibm.db2.jcc.t4.sb.h(sb.java:141)

at com.ibm.db2.jcc.a.rl.Y(rl.java:1873)

at com.ibm.db2.jcc.a.sl.bc(sl.java:2526)

at com.ibm.db2.jcc.a.sl.gc(sl.java:2632)

at com.ibm.db2.jcc.a.sl.a(sl.java:443)

at com.ibm.db2.jcc.a.ib.a(ib.java:2016)

at com.ibm.db2.jcc.a.ib.prepareStatement(ib.java:1584)

at com.sap.sql.jdbc.basic.BasicConnection.prepareStatement(BasicConnection.java:149)

at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:1286)

at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:257)

at com.sap.sql.jdbc.common.CommonPooledStatement.prepareDirectStatement(CommonPooledStatement.java:771)

at com.sap.sql.jdbc.common.CommonPooledStatement.<init>(CommonPooledStatement.java:300)

at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareStatement(CommonConnectionImpl.java:435)

at com.sap.sql.sqlj.common.runtime.FakeConnectionContext$FakeConnectedProfile.getStatement(FakeConnectionContext.java:173)

at sqlj.runtime.ExecutionContext$StatementStack.setStatement(ExecutionContext.java:1033)

at sqlj.runtime.ExecutionContext.registerStatement(ExecutionContext.java:653)

at com.virsa.ae.dao.sqlj.DeleteAllRequestsDAO.deleteAllRequests(DeleteAllRequestsDAO.sqlj:122)

... 4 more

[Former Member · Accepted solution]

HI Ian,

Just to be sure, Did you import the initial files for SP12 again?

Have a look at the post installation steps in this deck. They provide steps to be performed when upgrading a support pack in GRC 5.3.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0f0e585-1f57-2b10-ac80-8f6c37b94...

Thanks,

Chinmaya

Edited by: chinmaya prakash on Dec 17, 2010 7:55 PM

[Former Member]

Hi,

Even I didn't find any option to delete all the test data. Did you raise a request to SAP? Let me also look for the solution and I will post you as soon as I've an update.

Regards,

Raghu