Sql Error 3617

General discussion forum about all databases other than SqlBase.
Subbulakshmi

Sql Error 3617

Post by Subbulakshmi » 21 May 2014, 08:28

Hi All,

I'm using Team Developer 6.1 and Sql server 2005. Only two of the users are getting the below error when trying to access a menu. We swaped the machine and tested, so who ever logged in the machine they are getting. if they logged in other machine they are not getting the error. Seems machine related.

First the sql query came in the message box and then the sql error.
So i want to know waht could be the reason . We ran the registry cleaner and checked still getting the smae error. How to iterate the issue to solve the problem.

Could you all pease help.

Regards
Subbu
You do not have the required permissions to view the files attached to this post.

Ana Paula Bonani

Re: Sql Error 3617

Post by Ana Paula Bonani » 21 May 2014, 14:07

Hi,

A little research pointed me to this link: http://social.msdn.microsoft.com/Forums ... aproviders

So that doesn't look like a TD problem.

But if you believe that's TD-related we will need a small reprocase please.

Thanks,

Subbulakshmi

Re: Sql Error 3617

Post by Subbulakshmi » 22 May 2014, 05:43

Hi

Thanks for the reply, i too saw that, but it doest have SP51 as mentioned in the link.

Regards
Subbu

Subbulakshmi

Re: Sql Error 3617

Post by Subbulakshmi » 23 May 2014, 05:41

Hi,

Even if i give a test case i'm not sure whether it will reproduce in your system because its not occuring to all.

This error SQl Error3617 occurs when trying to execute the below query

Set sgSql = 'SELECT rowid, movement_amount
INTO :CdfInputAdjustSys.siRowId, :MyValue
FROM sysadm.movement_cntrl_unt
WHERE effective_date = :CdfInputAdjustSys.siDate
AND fund_number = :CdfInputAdjustSys.siFundNumber
AND sector_number = :CdfInputAdjustSys.siSectorNumber
AND subsector_number = :CdfInputAdjustSys.siSubsectorNumber
AND movement_type = :CdfInputAdjustSys.siMovementType
AND switch_or_flow = :CdfInputAdjustSys.siSwitchOrFlow
AND dllr_or_unit = :CdfInputAdjustSys.siDllrOrUnit
AND source_system = :CdfInputAdjustSys.siSourceSystem '
Call SalStrTrim( sgSql, sgSql )
If SqlPrepare( hWndForm.hSqlTable, sgSql )
If SqlExecute( hWndForm.hSqlTable )
Call SqlFetchNext( hWndForm.hSqlTable, nFetch )

I suspect that some required DLL might be missing in those machines. May i know what are all the required Dlls related when using SqlExecute statement.

Please advise.

REgards
Subbu

Ana Paula Bonani

Re: Sql Error 3617

Post by Ana Paula Bonani » 23 May 2014, 19:05

Hi

If you use a tool like Process Explorer or Dependency Walker it will tell you if you're missing any DLLs. It will also show you which DLLs are required.

Regards,

Subbulakshmi

Re: Sql Error 3617

Post by Subbulakshmi » 26 May 2014, 07:30

Hi,

I have tried Process exlorer it didnt say any missing DLL's. i copied all DLL's (from the working machine of C:\Program Files\Unify) to the non working machine, but no luck, still getitng the same error.

Any idea?

Regards
Subbu

Subbulakshmi

Re: Sql Error 3617

Post by Subbulakshmi » 28 May 2014, 07:19

THe error occurs when trying to execute the attached abouve query using SlqprepareandExecute statement. How to break and find out the exact root cause.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests