Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Err_Class = 7400 Error_Code = 5177

10 posts in Trigger Last posting was on 2008-03-11 08:30:41.0Z
Robert Heuvel Posted on 2008-03-06 12:58:48.0Z
From: "Robert Heuvel" <robert.heuvel@isopass.com>
Newsgroups: advantage.trigger
Subject: Err_Class = 7400 Error_Code = 5177
Date: Thu, 6 Mar 2008 13:58:48 +0100
Lines: 4
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 91.6.171.42
Message-ID: <47cfe93b@solutions.advantagedatabase.com>
X-Trace: 6 Mar 2008 05:53:15 -0700, 91.6.171.42
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!91.6.171.42
Xref: solutions.advantagedatabase.com Advantage.Trigger:365
Article PK: 1136425

Trigger running in implicit transaction seems to generate this error.

What does it mean?


Lance Schmidt Posted on 2008-03-06 16:39:13.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: advantage.trigger
References: <47cfe93b@solutions.advantagedatabase.com>
Subject: Re: Err_Class = 7400 Error_Code = 5177
Date: Thu, 6 Mar 2008 09:39:13 -0700
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.197
Message-ID: <47d01ce1@solutions.advantagedatabase.com>
X-Trace: 6 Mar 2008 09:33:37 -0700, 10.24.38.197
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.197
Xref: solutions.advantagedatabase.com Advantage.Trigger:366
Article PK: 1136427

Hi Robert,

The error message will more details about what happened.

Best Regards,

Lance Schmidt
Advantage R&D

"Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
news:47cfe93b@solutions.advantagedatabase.com...
> Trigger running in implicit transaction seems to generate this error.
>
> What does it mean?
>


Robert Heuvel Posted on 2008-03-07 15:13:14.0Z
From: "Robert Heuvel" <robert.heuvel@isopass.com>
Newsgroups: advantage.trigger
References: <47cfe93b@solutions.advantagedatabase.com> <47d01ce1@solutions.advantagedatabase.com>
In-Reply-To: <47d01ce1@solutions.advantagedatabase.com>
Subject: Re: Err_Class = 7400 Error_Code = 5177
Date: Fri, 7 Mar 2008 16:13:14 +0100
Lines: 25
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 91.6.170.40
Message-ID: <47d15a41@solutions.advantagedatabase.com>
X-Trace: 7 Mar 2008 08:07:45 -0700, 91.6.170.40
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!91.6.170.40
Xref: solutions.advantagedatabase.com Advantage.Trigger:367
Article PK: 1136429

pardon?

5177 is documented, 7400 isn't, so, what does it mean?

"Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
news:47d01ce1@solutions.advantagedatabase.com...

> Hi Robert,
>
> The error message will more details about what happened.
>
> Best Regards,
>
> Lance Schmidt
> Advantage R&D
>
>
> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
> news:47cfe93b@solutions.advantagedatabase.com...
>> Trigger running in implicit transaction seems to generate this error.
>>
>> What does it mean?
>>
>
>


Lance Schmidt Posted on 2008-03-07 16:36:31.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: advantage.trigger
References: <47cfe93b@solutions.advantagedatabase.com> <47d01ce1@solutions.advantagedatabase.com> <47d15a41@solutions.advantagedatabase.com>
Subject: Re: Err_Class = 7400 Error_Code = 5177
Date: Fri, 7 Mar 2008 09:36:31 -0700
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.197
Message-ID: <47d16dbe@solutions.advantagedatabase.com>
X-Trace: 7 Mar 2008 09:30:54 -0700, 10.24.38.197
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.197
Xref: solutions.advantagedatabase.com Advantage.Trigger:369
Article PK: 1136431

Hi Robert,

7400 is a an ACE error raised on the server. What is the text of the
exception you are getting.

Lance.

"Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
news:47d15a41@solutions.advantagedatabase.com...
> pardon?
>
> 5177 is documented, 7400 isn't, so, what does it mean?
>
> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
> news:47d01ce1@solutions.advantagedatabase.com...
>> Hi Robert,
>>
>> The error message will more details about what happened.
>>
>> Best Regards,
>>
>> Lance Schmidt
>> Advantage R&D
>>
>>
>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>> news:47cfe93b@solutions.advantagedatabase.com...
>>> Trigger running in implicit transaction seems to generate this error.
>>>
>>> What does it mean?
>>>
>>
>>
>


Robert Heuvel Posted on 2008-03-10 14:58:38.0Z
From: "Robert Heuvel" <robert.heuvel@isopass.com>
Newsgroups: advantage.trigger
References: <47cfe93b@solutions.advantagedatabase.com> <47d01ce1@solutions.advantagedatabase.com> <47d15a41@solutions.advantagedatabase.com> <47d16dbe@solutions.advantagedatabase.com>
In-Reply-To: <47d16dbe@solutions.advantagedatabase.com>
Subject: Re: Err_Class = 7400 Error_Code = 5177
Date: Mon, 10 Mar 2008 15:58:38 +0100
Lines: 58
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 91.6.174.67
Message-ID: <47d54b57@solutions.advantagedatabase.com>
X-Trace: 10 Mar 2008 08:53:11 -0700, 91.6.174.67
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!91.6.174.67
Xref: solutions.advantagedatabase.com Advantage.Trigger:371
Article PK: 1136433

Server logs 7400/5177
Clients logs 7200/5177 and 7200/5035

15:52:00.433 ERROR (TAdsTestProductMaterialTrigger): Error 5177: Trigger
execution failed. TrigError 7200: ProductMaterials Nr="H0010"
MandID="105"
Error 7200: AQE Error: State = HY000; NativeError = 5177; [Extended
Systems][Advantage SQL][ASA] Error 5177: Trigger execution failed.
TrigError 7200: ProductStocks Nr="H0010"
Error 7200: AQE Error: State = HY000; NativeError = 5035; [Extended
Systems][Advantage SQL][ASA] Error 5035: The requested lock could not be
granted. The file or record may be locked by another
user.(EADSDatabaseError) / done

happens inside of a trigger (triggers seem to have a few problems (memory,
system stability,..), only workaround is to invoke triggers (via
AdsTable.Post in separate database connection and close connection
immediately after use...)

"Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
news:47d16dbe@solutions.advantagedatabase.com...

> Hi Robert,
>
> 7400 is a an ACE error raised on the server. What is the text of the
> exception you are getting.
>
> Lance.
>
> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
> news:47d15a41@solutions.advantagedatabase.com...
>> pardon?
>>
>> 5177 is documented, 7400 isn't, so, what does it mean?
>>
>> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
>> news:47d01ce1@solutions.advantagedatabase.com...
>>> Hi Robert,
>>>
>>> The error message will more details about what happened.
>>>
>>> Best Regards,
>>>
>>> Lance Schmidt
>>> Advantage R&D
>>>
>>>
>>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>>> news:47cfe93b@solutions.advantagedatabase.com...
>>>> Trigger running in implicit transaction seems to generate this error.
>>>>
>>>> What does it mean?
>>>>
>>>
>>>
>>
>
>


Lance Schmidt Posted on 2008-03-10 23:17:35.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: advantage.trigger
References: <47cfe93b@solutions.advantagedatabase.com> <47d01ce1@solutions.advantagedatabase.com> <47d15a41@solutions.advantagedatabase.com> <47d16dbe@solutions.advantagedatabase.com> <47d54b57@solutions.advantagedatabase.com>
Subject: Re: Err_Class = 7400 Error_Code = 5177
Date: Mon, 10 Mar 2008 17:17:35 -0600
Lines: 72
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.197
Message-ID: <47d5c03e@solutions.advantagedatabase.com>
X-Trace: 10 Mar 2008 17:11:58 -0700, 10.24.38.197
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.197
Xref: solutions.advantagedatabase.com Advantage.Trigger:372
Article PK: 1136432

Hi Robert,

What version of Advantage are you using? In versions of Advantage prior to
8.0 AFTER triggers could not update the original record.

Best Regards,

Lance Schmidt
Advantage R&D

"Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
news:47d54b57@solutions.advantagedatabase.com...
> Server logs 7400/5177
> Clients logs 7200/5177 and 7200/5035
>
> 15:52:00.433 ERROR (TAdsTestProductMaterialTrigger): Error 5177: Trigger
> execution failed. TrigError 7200: ProductMaterials Nr="H0010"
> MandID="105"
> Error 7200: AQE Error: State = HY000; NativeError = 5177; [Extended
> Systems][Advantage SQL][ASA] Error 5177: Trigger execution failed.
> TrigError 7200: ProductStocks Nr="H0010"
> Error 7200: AQE Error: State = HY000; NativeError = 5035; [Extended
> Systems][Advantage SQL][ASA] Error 5035: The requested lock could not be
> granted. The file or record may be locked by another
> user.(EADSDatabaseError) / done
>
> happens inside of a trigger (triggers seem to have a few problems (memory,
> system stability,..), only workaround is to invoke triggers (via
> AdsTable.Post in separate database connection and close connection
> immediately after use...)
>
> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
> news:47d16dbe@solutions.advantagedatabase.com...
>> Hi Robert,
>>
>> 7400 is a an ACE error raised on the server. What is the text of the
>> exception you are getting.
>>
>> Lance.
>>
>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>> news:47d15a41@solutions.advantagedatabase.com...
>>> pardon?
>>>
>>> 5177 is documented, 7400 isn't, so, what does it mean?
>>>
>>> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
>>> news:47d01ce1@solutions.advantagedatabase.com...
>>>> Hi Robert,
>>>>
>>>> The error message will more details about what happened.
>>>>
>>>> Best Regards,
>>>>
>>>> Lance Schmidt
>>>> Advantage R&D
>>>>
>>>>
>>>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>>>> news:47cfe93b@solutions.advantagedatabase.com...
>>>>> Trigger running in implicit transaction seems to generate this error.
>>>>>
>>>>> What does it mean?
>>>>>
>>>>
>>>>
>>>
>>
>>
>


Robert Heuvel Posted on 2008-03-11 07:38:48.0Z
From: "Robert Heuvel" <robert.heuvel@isopass.com>
Newsgroups: advantage.trigger
References: <47cfe93b@solutions.advantagedatabase.com> <47d01ce1@solutions.advantagedatabase.com> <47d15a41@solutions.advantagedatabase.com> <47d16dbe@solutions.advantagedatabase.com> <47d54b57@solutions.advantagedatabase.com> <47d5c03e@solutions.advantagedatabase.com>
In-Reply-To: <47d5c03e@solutions.advantagedatabase.com>
Subject: Re: Err_Class = 7400 Error_Code = 5177
Date: Tue, 11 Mar 2008 08:38:48 +0100
Lines: 76
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 91.6.170.135
Message-ID: <47d635be@solutions.advantagedatabase.com>
X-Trace: 11 Mar 2008 01:33:18 -0700, 91.6.170.135
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!91.6.170.135
Xref: solutions.advantagedatabase.com Advantage.Trigger:373
Article PK: 1136434

8.10.0.25 and 8.10.0.18
"Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
news:47d5c03e@solutions.advantagedatabase.com...

> Hi Robert,
>
> What version of Advantage are you using? In versions of Advantage prior
> to 8.0 AFTER triggers could not update the original record.
>
> Best Regards,
>
> Lance Schmidt
> Advantage R&D
>
> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
> news:47d54b57@solutions.advantagedatabase.com...
>> Server logs 7400/5177
>> Clients logs 7200/5177 and 7200/5035
>>
>> 15:52:00.433 ERROR (TAdsTestProductMaterialTrigger): Error 5177: Trigger
>> execution failed. TrigError 7200: ProductMaterials Nr="H0010"
>> MandID="105"
>> Error 7200: AQE Error: State = HY000; NativeError = 5177; [Extended
>> Systems][Advantage SQL][ASA] Error 5177: Trigger execution failed.
>> TrigError 7200: ProductStocks Nr="H0010"
>> Error 7200: AQE Error: State = HY000; NativeError = 5035; [Extended
>> Systems][Advantage SQL][ASA] Error 5035: The requested lock could not be
>> granted. The file or record may be locked by another
>> user.(EADSDatabaseError) / done
>>
>> happens inside of a trigger (triggers seem to have a few problems
>> (memory, system stability,..), only workaround is to invoke triggers (via
>> AdsTable.Post in separate database connection and close connection
>> immediately after use...)
>>
>> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
>> news:47d16dbe@solutions.advantagedatabase.com...
>>> Hi Robert,
>>>
>>> 7400 is a an ACE error raised on the server. What is the text of the
>>> exception you are getting.
>>>
>>> Lance.
>>>
>>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>>> news:47d15a41@solutions.advantagedatabase.com...
>>>> pardon?
>>>>
>>>> 5177 is documented, 7400 isn't, so, what does it mean?
>>>>
>>>> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
>>>> news:47d01ce1@solutions.advantagedatabase.com...
>>>>> Hi Robert,
>>>>>
>>>>> The error message will more details about what happened.
>>>>>
>>>>> Best Regards,
>>>>>
>>>>> Lance Schmidt
>>>>> Advantage R&D
>>>>>
>>>>>
>>>>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>>>>> news:47cfe93b@solutions.advantagedatabase.com...
>>>>>> Trigger running in implicit transaction seems to generate this error.
>>>>>>
>>>>>> What does it mean?
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>


Robert Heuvel Posted on 2008-03-11 08:30:41.0Z
From: "Robert Heuvel" <robert.heuvel@isopass.com>
Newsgroups: advantage.trigger
References: <47cfe93b@solutions.advantagedatabase.com> <47d01ce1@solutions.advantagedatabase.com> <47d15a41@solutions.advantagedatabase.com> <47d16dbe@solutions.advantagedatabase.com> <47d54b57@solutions.advantagedatabase.com> <47d5c03e@solutions.advantagedatabase.com>
In-Reply-To: <47d5c03e@solutions.advantagedatabase.com>
Subject: Re: Err_Class = 7400 Error_Code = 5177
Date: Tue, 11 Mar 2008 09:30:41 +0100
Lines: 81
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 91.6.170.135
Message-ID: <47d641e7@solutions.advantagedatabase.com>
X-Trace: 11 Mar 2008 02:25:11 -0700, 91.6.170.135
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!91.6.170.135
Xref: solutions.advantagedatabase.com Advantage.Trigger:376
Article PK: 1136436

and the triggers do not update the same record or different record in same
table, they change other tables:

insert/update to tableA -> trigger tableA -> 1-2 updates to tableB ->
trigger on tableB -> update to tableC

"Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
news:47d5c03e@solutions.advantagedatabase.com...

> Hi Robert,
>
> What version of Advantage are you using? In versions of Advantage prior
> to 8.0 AFTER triggers could not update the original record.
>
> Best Regards,
>
> Lance Schmidt
> Advantage R&D
>
> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
> news:47d54b57@solutions.advantagedatabase.com...
>> Server logs 7400/5177
>> Clients logs 7200/5177 and 7200/5035
>>
>> 15:52:00.433 ERROR (TAdsTestProductMaterialTrigger): Error 5177: Trigger
>> execution failed. TrigError 7200: ProductMaterials Nr="H0010"
>> MandID="105"
>> Error 7200: AQE Error: State = HY000; NativeError = 5177; [Extended
>> Systems][Advantage SQL][ASA] Error 5177: Trigger execution failed.
>> TrigError 7200: ProductStocks Nr="H0010"
>> Error 7200: AQE Error: State = HY000; NativeError = 5035; [Extended
>> Systems][Advantage SQL][ASA] Error 5035: The requested lock could not be
>> granted. The file or record may be locked by another
>> user.(EADSDatabaseError) / done
>>
>> happens inside of a trigger (triggers seem to have a few problems
>> (memory, system stability,..), only workaround is to invoke triggers (via
>> AdsTable.Post in separate database connection and close connection
>> immediately after use...)
>>
>> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
>> news:47d16dbe@solutions.advantagedatabase.com...
>>> Hi Robert,
>>>
>>> 7400 is a an ACE error raised on the server. What is the text of the
>>> exception you are getting.
>>>
>>> Lance.
>>>
>>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>>> news:47d15a41@solutions.advantagedatabase.com...
>>>> pardon?
>>>>
>>>> 5177 is documented, 7400 isn't, so, what does it mean?
>>>>
>>>> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
>>>> news:47d01ce1@solutions.advantagedatabase.com...
>>>>> Hi Robert,
>>>>>
>>>>> The error message will more details about what happened.
>>>>>
>>>>> Best Regards,
>>>>>
>>>>> Lance Schmidt
>>>>> Advantage R&D
>>>>>
>>>>>
>>>>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>>>>> news:47cfe93b@solutions.advantagedatabase.com...
>>>>>> Trigger running in implicit transaction seems to generate this error.
>>>>>>
>>>>>> What does it mean?
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>


Robert Heuvel Posted on 2008-03-11 07:40:01.0Z
From: "Robert Heuvel" <robert.heuvel@isopass.com>
Newsgroups: advantage.trigger
References: <47cfe93b@solutions.advantagedatabase.com> <47d01ce1@solutions.advantagedatabase.com> <47d15a41@solutions.advantagedatabase.com> <47d16dbe@solutions.advantagedatabase.com> <47d54b57@solutions.advantagedatabase.com> <47d5c03e@solutions.advantagedatabase.com>
In-Reply-To: <47d5c03e@solutions.advantagedatabase.com>
Subject: Re: Err_Class = 7400 Error_Code = 5177
Date: Tue, 11 Mar 2008 08:40:01 +0100
Lines: 76
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 91.6.170.135
Message-ID: <47d63606@solutions.advantagedatabase.com>
X-Trace: 11 Mar 2008 01:34:30 -0700, 91.6.170.135
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!91.6.170.135
Xref: solutions.advantagedatabase.com Advantage.Trigger:374
Article PK: 1136437

both triggers are (at this time) "before" triggers
"Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
news:47d5c03e@solutions.advantagedatabase.com...

> Hi Robert,
>
> What version of Advantage are you using? In versions of Advantage prior
> to 8.0 AFTER triggers could not update the original record.
>
> Best Regards,
>
> Lance Schmidt
> Advantage R&D
>
> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
> news:47d54b57@solutions.advantagedatabase.com...
>> Server logs 7400/5177
>> Clients logs 7200/5177 and 7200/5035
>>
>> 15:52:00.433 ERROR (TAdsTestProductMaterialTrigger): Error 5177: Trigger
>> execution failed. TrigError 7200: ProductMaterials Nr="H0010"
>> MandID="105"
>> Error 7200: AQE Error: State = HY000; NativeError = 5177; [Extended
>> Systems][Advantage SQL][ASA] Error 5177: Trigger execution failed.
>> TrigError 7200: ProductStocks Nr="H0010"
>> Error 7200: AQE Error: State = HY000; NativeError = 5035; [Extended
>> Systems][Advantage SQL][ASA] Error 5035: The requested lock could not be
>> granted. The file or record may be locked by another
>> user.(EADSDatabaseError) / done
>>
>> happens inside of a trigger (triggers seem to have a few problems
>> (memory, system stability,..), only workaround is to invoke triggers (via
>> AdsTable.Post in separate database connection and close connection
>> immediately after use...)
>>
>> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
>> news:47d16dbe@solutions.advantagedatabase.com...
>>> Hi Robert,
>>>
>>> 7400 is a an ACE error raised on the server. What is the text of the
>>> exception you are getting.
>>>
>>> Lance.
>>>
>>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>>> news:47d15a41@solutions.advantagedatabase.com...
>>>> pardon?
>>>>
>>>> 5177 is documented, 7400 isn't, so, what does it mean?
>>>>
>>>> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
>>>> news:47d01ce1@solutions.advantagedatabase.com...
>>>>> Hi Robert,
>>>>>
>>>>> The error message will more details about what happened.
>>>>>
>>>>> Best Regards,
>>>>>
>>>>> Lance Schmidt
>>>>> Advantage R&D
>>>>>
>>>>>
>>>>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>>>>> news:47cfe93b@solutions.advantagedatabase.com...
>>>>>> Trigger running in implicit transaction seems to generate this error.
>>>>>>
>>>>>> What does it mean?
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>


Robert Heuvel Posted on 2008-03-11 08:27:14.0Z
From: "Robert Heuvel" <robert.heuvel@isopass.com>
Newsgroups: advantage.trigger
References: <47cfe93b@solutions.advantagedatabase.com> <47d01ce1@solutions.advantagedatabase.com> <47d15a41@solutions.advantagedatabase.com> <47d16dbe@solutions.advantagedatabase.com> <47d54b57@solutions.advantagedatabase.com> <47d5c03e@solutions.advantagedatabase.com> <47d63606@solutions.advantagedatabase.com>
In-Reply-To: <47d63606@solutions.advantagedatabase.com>
Subject: Re: Err_Class = 7400 Error_Code = 5177
Date: Tue, 11 Mar 2008 09:27:14 +0100
Lines: 82
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 91.6.170.135
Message-ID: <47d64117@solutions.advantagedatabase.com>
X-Trace: 11 Mar 2008 02:21:43 -0700, 91.6.170.135
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!91.6.170.135
Xref: solutions.advantagedatabase.com Advantage.Trigger:375
Article PK: 1136435

sorry, they are AFTER triggers, still waking (booting) up...

"Robert Heuvel" <robert.heuvel@isopass.com> schrieb im Newsbeitrag
news:47d63606@solutions.advantagedatabase.com...

> both triggers are (at this time) "before" triggers
> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
> news:47d5c03e@solutions.advantagedatabase.com...
>> Hi Robert,
>>
>> What version of Advantage are you using? In versions of Advantage prior
>> to 8.0 AFTER triggers could not update the original record.
>>
>> Best Regards,
>>
>> Lance Schmidt
>> Advantage R&D
>>
>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>> news:47d54b57@solutions.advantagedatabase.com...
>>> Server logs 7400/5177
>>> Clients logs 7200/5177 and 7200/5035
>>>
>>> 15:52:00.433 ERROR (TAdsTestProductMaterialTrigger): Error 5177:
>>> Trigger execution failed. TrigError 7200: ProductMaterials Nr="H0010"
>>> MandID="105"
>>> Error 7200: AQE Error: State = HY000; NativeError = 5177; [Extended
>>> Systems][Advantage SQL][ASA] Error 5177: Trigger execution failed.
>>> TrigError 7200: ProductStocks Nr="H0010"
>>> Error 7200: AQE Error: State = HY000; NativeError = 5035; [Extended
>>> Systems][Advantage SQL][ASA] Error 5035: The requested lock could not
>>> be granted. The file or record may be locked by another
>>> user.(EADSDatabaseError) / done
>>>
>>> happens inside of a trigger (triggers seem to have a few problems
>>> (memory, system stability,..), only workaround is to invoke triggers
>>> (via AdsTable.Post in separate database connection and close connection
>>> immediately after use...)
>>>
>>> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
>>> news:47d16dbe@solutions.advantagedatabase.com...
>>>> Hi Robert,
>>>>
>>>> 7400 is a an ACE error raised on the server. What is the text of the
>>>> exception you are getting.
>>>>
>>>> Lance.
>>>>
>>>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>>>> news:47d15a41@solutions.advantagedatabase.com...
>>>>> pardon?
>>>>>
>>>>> 5177 is documented, 7400 isn't, so, what does it mean?
>>>>>
>>>>> "Lance Schmidt" <LanceSc@ExtendSys.com> schrieb im Newsbeitrag
>>>>> news:47d01ce1@solutions.advantagedatabase.com...
>>>>>> Hi Robert,
>>>>>>
>>>>>> The error message will more details about what happened.
>>>>>>
>>>>>> Best Regards,
>>>>>>
>>>>>> Lance Schmidt
>>>>>> Advantage R&D
>>>>>>
>>>>>>
>>>>>> "Robert Heuvel" <robert.heuvel@isopass.com> wrote in message
>>>>>> news:47cfe93b@solutions.advantagedatabase.com...
>>>>>>> Trigger running in implicit transaction seems to generate this
>>>>>>> error.
>>>>>>>
>>>>>>> What does it mean?
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>