Goldmine API Connection Problem

[visaarn]

We have developed a workflow / process control system. PHP driven / SQL script batch process that reads information from a series of user defined screen tabs, then generates a table of intended actions. The PHP / SQL script reads these actions and then writes history and tasks back to Goldmine via the API. It then flings out case progress emails to our IFA customers. An email log is sent to me at completion recording the actions.

PHP scripts run from NT machine, link to win2k machine via socket server PHP scripts and use the API to create records on another win2k machine with the SQL database on.

The batch process runs every hour for weeks at a time and then for an hour or so may show "unable to connect to Golddmine" application messages in the email log. Some failures appear to fix temselves partway through a batch.

All instinct is pointing to connection problems between the two win2k boxes. Our network guys are beginning to look at this, our DBA's are fairly convinced too.

ANY OTHER IDEAS ?


.
Goldmine info:
Product = Corporate Edition with GoldSync®
License = E-0020-30366656
Versions = GoldMine 6.50.31113, BDE 500 [4/11/1999], Windows NT 5.00.2195 Service Pack 4
SQL Server = Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
GoldMine EXE = \\eags40cod03\gmdev\gmw6.exe
BDE DLL Files = \\eags40cod03\gmdev\setup\bdeshare
TEMP Directory = c:\docume~1\coatesj\locals~1\temp\
System Files = \\eags40cod03\gmdev\
GoldMine Files = MSSQL: GM_DEV: dbo.
Contact Files = MSSQL: GM_DEV: dbo.
Free Disk Space = C: 37,098 MB
Memory (RAM) = 515 MB
Open Cursors = 13
Logged User = MASTER [Master!] [SQL Login: gold_admin]
CAL LangDriver = DBWINUS0 [New RecID]
Contact1 LangDriver = DBWINUS0 [New RecID]
Tx32 version = 801

 

[richardy]

Hi,

Run GoldMine on that machine to make sure you can log into GoldMine. I suspect that it simply cant get to GoldMine via the connection. You could try getting to the SQL via standard ODBC and see if that works as well.


Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

 

[visaarn]

Richard,

Thanks for responding. We have been digging a bit deeper and tracing routes between boxes has revealed a connection that sometimes take 5 seconds. Our PHP socket server connection timeout has been coded at 2 seconds - doesn't stand a chance. We will get out network teckies to look at the cause and if necessary increase our timeout. I begrudge the extra few seconds though !