CE9 Database errors

[jrperry]

Has anyone come across the following message:

Database access error. Reason [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'APS_InfoObjects2' with unique index 'APS_InfoObjects2_I1'..

We use SQL Server as the CE9 database.

This error appears to be caused when copying or moving report or folder objects in CE9. It continues to occur until APS database access fails.

The error also seems to cause 'Invalid Logon Token' error messages, resulting in problems for users accessing the reports.

I have patched to the lastest monthly CE90 patches and have recently reinitialized the database.

Any help appreciated.

 

[Turkbear]

Hi,
If you move or copy to a folder that already has an object of the same ID# , that is the message you will get..
Is that the case?

( If so, delete the object in the target location before copying or moving the new version)

 

[ferdio]

Heya Jerry - we have just encountered this problem also - same version same DB etc...

Did you ever work it out ??

Would really appreciate some info if you have any.

Regards,

Ferdi Oosterhoff.

 

[jrperry]

Hi Ferdio,

We have this problem from time to time and when it does happen there is not much to go on. I have set up trace levels on all components and the information has been passed on to our local support company but no real solution has been found.

I will keep you updated, but if you find something please advise.

Cheers

 

[EcofAcer]

Dude that's an ODBC driver error. Do you think you may have a whaked ODBC? Have you run any integrity check on the database?

 

[Turkbear]

Hi, It is not the ODBC, that is a SqlServer ( or MSDE) error message..Did you check the target folder for an entry that has the same ID#...

Cannot insert duplicate key row in object 'APS_InfoObjects2' with unique index 'APS_InfoObjects2_I1'..

Means that the Index has an entry with that key already.

 

[ferdio]

Thanks for replies.

It turns out however that the error:

Database access error. Reason [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'APS_InfoObjects2' with unique index 'APS_InfoObjects2_I1

seems to be a bit of a red-herring. Re-starting the page server seems to return the system to normal operation for a while. Eventually the report viewing will break-down, and the above error message will reappear in the event logs. It seems to be a Page Server error with the above error turning up as a consequent symptom.

Thoughts welcome...

 

[jrperry]

You could be right Ferdio,

Do you use a generic user id for users or do they have unique authentication.

 

[ferdio]

Individual logins and I believe it's all Enterprise authentication...

 

[jrperry]

FERDIO,

If you still are experiencing this issue, can you check how your ODBC connection to the APS is setup, in particular, have you checked the 'use regional settings' option.

Also, check to see if your regional settings for the APS or Crsytal Enterprise server is set to US or local setting.

Please let me know as I have changed these settings and I have had a stable environment since. Hopefully this will hold!

 

[ifranc]

Hi

I'm experiencing the same issue and wondered if your system is still stable based on your last suggestion or if any new info has come to light?

cheers
Franc

 

[jrperry]

System is now stable with no issues since changing ODBC