How solve this case? I can not load to server.
How solve this case? I can not load to server.
I had the same issue today.
My issue was coming from the comment I entered in the rollback window.
I entered the following text (in bold) 'AL and got the issue
It seems that the comment text is interpreted by EPDM.
Here is an extract from the log file :
"
Error running query in SpDbOdbc State=37000
Msg=[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'AL'.
========= LAST COMMAND ========
Exec SPRB_Rollback 2, 154629, 16, 0, N'Annulation de la modification d'AL en rev B : le corps raccourci pour le 904L devient le R29463'
Server: xxxx
Database: xxxx
"
When I entered the same comment but replacing 'AL by aurelien , the issue disappeared and I was able to rollback.
So avoid the ' in your comments.
Hope this was helpfull for you
Thank you Frederic!!!! Saved me a bunch of hassle.
I just came across this same issue. Thank you for your solution! I'm also incredibly shocked that SW PDM doesn't sanitize their text inputs.
Checking Google here are a couple of clues. I would say check your log as described by Javelin and see if it give you any additional info. Unfortunately with so little to go on it could be anything.
http://www.javelin-tech.com/blog/2014/06/epdm-access-item-database/#.WMagDG8rLmE
"Could not access the item in the database" when trying to destroy deleted items
What is going on!? "Could not access Item in the Database" | MySolidWorks