SCC error 7008

[Former Member]

Hello!

I hope someone can help me.

I'm getting the error below when I try to do any action on the SCC.

For example: Registrer or unregister a user (application connection) or unblock an item on the workflow's queue items.

2014-01-28 10:58:05.719 ERROR MMS Thread-210 [com.sybase.sup.admin.server.ServerAdminImpl]ServerAdminImpl.logException

  at java.lang.Thread.run(Thread.java:662)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

  at com.sybase.djc.rmi.iiop.server.MessageHandler.run(MessageHandler.java:310)

  at com.sybase.djc.rmi.iiop.server.MessageHandler.processRequest(MessageHandler.java:798)

  at com.sybase.sup.admin.server.DOECServerAdminImpl_DJC.$invoke(DOECServerAdminImpl_DJC.java:271)

  at com.sybase.sup.admin.server.DOECServerAdminImpl_DJC.$invoke_0(DOECServerAdminImpl_DJC.java:604)

  at com.sybase.sup.admin.server.ServerAdminImpl.deleteApplicationConnection(ServerAdminImpl.java:4338)

java.lang.RuntimeException: Delete Application Connection failed. LogicId:4171 ErrorCode:1 ErrorMessage:Device Deletion Error: Error 7200:  AQE Error:  State = HY000;   NativeError = 7008;  [iAnywhere Solutions][Advantage SQL][ASA] Error 7008:  The specified table, memo file, or index file was unable to be opened.   UPDATE DEVICES SET "SOFT_DELETE_DT" = NOW() WHERE DEVICE_ID = 4171

What file is missing?

Thanks in advance.

Looking forward to hearing from you.

[Jitendra_Kansal · Accepted solution]

just give a try:

1. stop all sup related services (from desktop icon, stop unwired platform services)

2. cross check in services.msc if all services have been stopped, make their Start Type as manual (if not)

3. restart your machine

4. start all sup related services (from desktop icon, start unwired platform services)

5. once again cross check in services.msc if all services have been started successfully.

6. open scc and try to delete/register a user

you can raise a ticket in sap support for much assistance.

[Former Member · Accepted solution]

Didn't work.

I will raise a ticket in Sap support.

Anyway, thanks a lot!

[midhun_vp]

What is the version of the Server ? Is the server a fresh installation ? Whether you were able to do tasks before ?

Related links,

- Midhun VP

[Former Member]

Version 2.1.3

It was working properly until yesterday.

Find below some log:

20140128T021521.353|1|Exception thrown trying to reset online flags, error = ExecuteCommand, Com Error Code:  -2147217900, Com Error Desc:  Error 7200:  AQE Error:  State = HY000;   NativeError = 7008;  [iAnywhere Solutions][Advantage SQL][ASA] Error 7008:  The specified table, memo file, or index file was unable to be opened.   UPDATE DEVICE_CONNECTIONS SET IS_CONNECTED = False WHERE COMPUTER_NAME =

[Former Member]

Version 2.1.3.231

[midhun_vp]

I am assuming that some files are corrupted in the SUP server, you can reach out to SAP to get a solution on this. Editing or replacing the files solves the problem.

- Midhun VP

[Former Member]

Do you have a data tier, i.e. this is not a single node installation right?

[Former Member]

Lee,

We have a single node installation.

[Former Member]

VP,

do you know which file stores the database?