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.

Error BIGDOG

3 posts in Trigger Last posting was on 2009-09-28 03:04:01.0Z
"Saras Setiawan" Posted on 2009-09-17 09:23:38.0Z
From: "Saras Setiawan" <saras[at]epsylonhome[dot]com>
Newsgroups: Advantage.Trigger
Subject: Error BIGDOG
Date: Thu, 17 Sep 2009 16:23:38 +0700
Lines: 11
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.3138
X-RFC2646: Format=Flowed; Original
X-Antivirus: avast! (VPS 090916-0, 16/09/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 118.137.207.4
Message-ID: <4ab1ffbc@solutions.advantagedatabase.com>
X-Trace: 17 Sep 2009 03:22:04 -0700, 118.137.207.4
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!118.137.207.4
Xref: solutions.advantagedatabase.com Advantage.Trigger:449
Article PK: 1136510

Hi,

Error 5041: The requested object was not found:
H:\BIGDOG\SERVER\Cconnect.cpp, 7250
We can not solve this problem.
Can anybody help us?

Regards
Saras Setiawan


Mark Wilkins Posted on 2009-09-18 14:19:45.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.Trigger
References: <4ab1ffbc@solutions.advantagedatabase.com>
Subject: Re: Error BIGDOG
Date: Fri, 18 Sep 2009 08:19:45 -0600
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 10.24.38.228
Message-ID: <4ab396b0@solutions.advantagedatabase.com>
X-Trace: 18 Sep 2009 08:18:24 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Trigger:450
Article PK: 1136511

Hi Saras,

What version of Advantage Database Server are you using? I found an entry
in our bug database that describes this possibility. It can occur if an
application drops and creates triggers at run time (for example, run
operations that exercise a trigger, drop the trigger, create the trigger,
try to exercise the trigger again). It was fixed in v9.0.0.7. However, it
is not clear to me if the problem exists in the v9.1.x branch or not. I
need to talk to someone else about that.

Mark Wilkins
Advantage R&D

"Saras Setiawan" <saras[at]epsylonhome[dot]com> wrote in message
news:4ab1ffbc@solutions.advantagedatabase.com...
> Hi,
>
> Error 5041: The requested object was not found:
> H:\BIGDOG\SERVER\Cconnect.cpp, 7250
> We can not solve this problem.
> Can anybody help us?
>
> Regards
> Saras Setiawan
>


"Saras Setiawan" Posted on 2009-09-28 03:04:01.0Z
From: "Saras Setiawan" <saras[at]epsylonhome[dot]com>
Newsgroups: Advantage.Trigger
References: <4ab1ffbc@solutions.advantagedatabase.com> <4ab396b0@solutions.advantagedatabase.com>
Subject: Re: Error BIGDOG
Date: Mon, 28 Sep 2009 10:04:01 +0700
Lines: 97
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.3138
X-RFC2646: Format=Flowed; Response
X-Antivirus: avast! (VPS 090927-0, 27/09/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 118.137.207.4
Message-ID: <4ac02731@solutions.advantagedatabase.com>
X-Trace: 27 Sep 2009 21:02:09 -0700, 118.137.207.4
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!118.137.207.4
Xref: solutions.advantagedatabase.com Advantage.Trigger:451
Article PK: 1136512

Hi Mark,
Our client still use ADS 8.10.0.26.
We wanna deactivate the trigger if we had no solution about this problem.

Thanks & Best Regards
Saras Setiawan

// Description: TRIGGER INSERT for CLIENT
////////////////////////////////////////////////////////////////////////////////
DECLARE @thdCURSOR CURSOR;
DECLARE @usrCURSOR CURSOR;
DECLARE @dbCURSOR CURSOR;
DECLARE @tmpCURSOR CURSOR;

DECLARE @myComputer STRING;
DECLARE @myAddress STRING;
DECLARE @myLogin STRING;

DECLARE @oldValue STRING;
DECLARE @newValue STRING;

//////////////////////////////////////////////////////////////////////////////
.....

//////////////////////////////////////////////////////////////////////////////
@oldValue = '';
@newValue = '';
OPEN @tmpCURSOR AS SELECT CAST(n.CUSTOMERNO AS SQL_CHAR)+'
:'+CAST(n.CUSTOMERNM AS SQL_CHAR)+
.....
AS OLDVALUE, '' AS NEWVALUE FROM __NEW n;
TRY
FETCH @tmpCURSOR;
@oldValue = @tmpCURSOR.OLDVALUE;
@newValue = @tmpCURSOR.NEWVALUE;
FINALLY
CLOSE @tmpCURSOR;
END;
//////////////////////////////////////////////////////////////////////////////
INSERT INTO MAUDIT ( ComputerName,
UserName,
UserApplication,
UserDictionary,
IPAddress,
ApplicationID,
TableName,
EventType,
DateTime,
_OldValue,
_NewValue )
VALUES ( @myComputer,
@myLogin,
'',
User(),
@myAddress,
ApplicationID(),
'CLIENT',
'INSERT',
Now(),
@oldValue,
@newValue );

"Mark Wilkins" <mark@no.email> wrote in message
news:4ab396b0@solutions.advantagedatabase.com...
> Hi Saras,
>
> What version of Advantage Database Server are you using? I found an entry
> in our bug database that describes this possibility. It can occur if an
> application drops and creates triggers at run time (for example, run
> operations that exercise a trigger, drop the trigger, create the trigger,
> try to exercise the trigger again). It was fixed in v9.0.0.7. However,
> it is not clear to me if the problem exists in the v9.1.x branch or not.
> I need to talk to someone else about that.
>
> Mark Wilkins
> Advantage R&D
>
> "Saras Setiawan" <saras[at]epsylonhome[dot]com> wrote in message
> news:4ab1ffbc@solutions.advantagedatabase.com...
>> Hi,
>>
>> Error 5041: The requested object was not found:
>> H:\BIGDOG\SERVER\Cconnect.cpp, 7250
>> We can not solve this problem.
>> Can anybody help us?
>>
>> Regards
>> Saras Setiawan
>>
>
>