ContSupp Table SQL Blocking

[gpadmin]

Hello All,

We are running Goldmine 6.5.40321. Our ContSupp table randomly locks up and either the SQL server or the entire server needs to be restarted because no one can get into Goldmine. The blocking select statement is as follows, it appears to be somewhat truncated.

SELECT ACCOUNTNO ,RECTYPE ,CONTACT ,TITLE ,CONTSUPREF ,DEAR ,PHONE ,EXT ,FAX ,LINKACCT ,NOTES ,ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,CITY ,STATE ,ZIP ,COUNTRY ,MERGECODES ,STATUS ,LINKEDDOC ,LASTUSER ,LASTDATE ,LASTTIME ,U_CONTACT ,U_CONTSUPREF ,RECID FROM dbo.C


We then get:
General SQL Error
Native SQL Error: 10025

Context: SQLOptLockErrParam
dbo.CAL


Has anyone experienced this issue?

Thanks.

 

[richardy]

Hi,

Yep contact edward.houghton@frontrange.com for details on a resolution.

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.

 

[gpadmin]

Hello Richardy,

FRS is telling me that the SQL locking issues have been rectified in our build? Is this true? It has been happening with more frequency 4-7 times per day. Our reseller has also been struggling to find an answer.

 

[goner]

this could just be resource related on the server... 10025 is basically a network timeout-type thing. You might try ticking down the max amount of RAM that the SQL server is allowed to grab in the properties of the SQL server in the Ent. Manager. It may be grabbing so much RAM that the machine is forced into using the pagefile and therefore not responding to SQL requests in a timely enough fashion for some functions within the program.

Doug Castell
Computer Control Corp
(310)396-6811

http://www.ccc24k.com

 

[richardy]

Are you running any third party apps or customisations using the API?

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.

 

[allanc45]

Hello,

I've also recently started running into this problem. We are also using 6.5 GMCE SQL (using the April 04 build, can't recall the exact version).

I will also get this random lockup on the Contsupp table, and it will not allow any users to read the table or logon due to the block. If someone has an explanation or solution, I'd love to hear it.

I'll try contacting this guy who richardy recommends. Regarding memory - my server has 4gigs in it and SQLServer.exe never uses more than about 1.7 gigs. In Ent. Mgr, I have it set to use up to 3gigs.

 

[richardy]

Hi Allan,

Theres a temporary fix that kills the locks on

http://www.prior-analytics.com/forum/

Upgrading to 6.7.50123 will solve some of the locks as well. The other thing is a bug in the API for GoldMine so a third party program may be causing this without knowing it. The API issue is the RECORDOBJ command you must set a contact to primary or additional before using any commands otherwise it will try and pull everything from the contsupp continiously.

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.