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 7004

7 posts in Trigger Last posting was on 2006-07-07 13:38:26.0Z
Brent Nelson Posted on 2006-06-23 19:27:18.0Z
Date: Fri, 23 Jun 2006 13:27:18 -0600
From: Brent Nelson <bnelson@westernwats.com>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Error 7004
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.20.254.254
Message-ID: <449c3fbe@solutions.advantagedatabase.com>
X-Trace: 23 Jun 2006 13:23:42 -0700, 216.20.254.254
Lines: 42
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!216.20.254.254
Xref: solutions.advantagedatabase.com Advantage.Trigger:255
Article PK: 1136321

I am using the following trigger:

//:======================================================================://

DECLARE @compName STRING, @word STRING, @loopCheck LOGICAL;
DECLARE newSearchRecordPointer CURSOR;
OPEN newSearchRecordPointer AS SELECT * FROM __new;
TRY
WHILE FETCH newSearchRecordPointer DO
@compName = newSearchRecordPointer.c_compName;
@loopCheck = true;
END WHILE;
WHILE @loopCheck = true DO
IF LOCATE( ' ', TRIM( @compName ) ) >= 1 THEN
@word = TRIM( SUBSTRING( @compName, 1, LOCATE( ' ', @compName ) ) );
INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( @word );
@compName = SUBSTRING( @compName, LOCATE( ' ', @compName ),
LENGTH( @compName ) );
ELSE
INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( TRIM(
@compName ) );
@loopCheck = false;
END IF;
END WHILE;
FINALLY
CLOSE newSearchRecordPointer;
END TRY;

//:======================================================================://

But I am getting the following error:

Error 7004: Maximum number of work areas exceeded. Table name:
searchRecordPointers


I am unsure what I can do to fix this. Also, it seems that my trigger
runs really slow.

Thanks.

ebn


Lance Schmidt Posted on 2006-06-23 19:44:29.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: Advantage.Trigger
References: <449c3fbe@solutions.advantagedatabase.com>
Subject: Re: Error 7004
Date: Fri, 23 Jun 2006 13:44:29 -0600
Lines: 87
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 10.24.38.153
Message-ID: <449c43c3@solutions.advantagedatabase.com>
X-Trace: 23 Jun 2006 13:40:51 -0700, 10.24.38.153
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.153
Xref: solutions.advantagedatabase.com Advantage.Trigger:256
Article PK: 1136322

Hi Brent,

From the help files.

Advantage Database Server for NetWare

Problem: The maximum number of configured work areas are already in use.
Solution: Increase the setting for the WORKAREAS configuration value in the
Advantage Database Server for NetWare configuration file, ADS.CFG. If no
WORKAREAS configuration key exists in ADS.CFG, add one and set the value to
larger than the number of CONNECTIONS multiplied by 25 (which is the default
value for the number of work areas if no WORKAREAS configuration key
exists). Then re-load the Advantage Database Server for NetWare.

Advantage Database Server for Windows NT/2000/2003

Problem: The maximum number of configured work areas are already in use.
Solution: Increase the setting for the "Number of Work Areas" using the
Advantage Configuration Utility. If you don't wish to use the Advantage
Configuration Utility, increase the setting for the WORKAREAS configuration
value in the Advantage Database Server configuration registry key using the
Registry Editor. The Advantage Database Server Configuration Registry Key is
located in the Registry at:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Configuration.
Then re-start the Advantage Database Server for Windows NT/2000/2003.

Advantage Local Server

Problem: The maximum number of configured work areas are already in use.
Solution: Increase the setting for the WORKAREAS configuration value in the
Advantage Local Server configuration file, ADSLOCAL.CFG. If no WORKAREAS
configuration key exists in ADSLOCAL.CFG, add one and set the value to
larger than the number of CONNECTIONS multiplied by 25 (which is the default
value for the number of work areas if no WORKAREAS configuration key
exists). Then re-start the application that uses the Advantage Local Server.

Best Regards,

Lance Schmidt
Advantage R&D

"Brent Nelson" <bnelson@westernwats.com> wrote in message
news:449c3fbe@solutions.advantagedatabase.com...
>I am using the following trigger:
>
> //:======================================================================://
>
> DECLARE @compName STRING, @word STRING, @loopCheck LOGICAL;
> DECLARE newSearchRecordPointer CURSOR;
> OPEN newSearchRecordPointer AS SELECT * FROM __new;
> TRY
> WHILE FETCH newSearchRecordPointer DO
> @compName = newSearchRecordPointer.c_compName;
> @loopCheck = true;
> END WHILE;
> WHILE @loopCheck = true DO
> IF LOCATE( ' ', TRIM( @compName ) ) >= 1 THEN
> @word = TRIM( SUBSTRING( @compName, 1, LOCATE( ' ', @compName ) ) );
> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( @word );
> @compName = SUBSTRING( @compName, LOCATE( ' ', @compName ), LENGTH(
> @compName ) );
> ELSE
> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( TRIM(
> @compName ) );
> @loopCheck = false;
> END IF;
> END WHILE;
> FINALLY
> CLOSE newSearchRecordPointer;
> END TRY;
>
> //:======================================================================://
>
> But I am getting the following error:
>
> Error 7004: Maximum number of work areas exceeded. Table name:
> searchRecordPointers
>
>
> I am unsure what I can do to fix this. Also, it seems that my trigger runs
> really slow.
>
> Thanks.
>
> ebn


Brent Nelson Posted on 2006-06-23 20:02:07.0Z
Date: Fri, 23 Jun 2006 14:02:07 -0600
From: Brent Nelson <bnelson@westernwats.com>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Re: Error 7004
References: <449c3fbe@solutions.advantagedatabase.com> <449c43c3@solutions.advantagedatabase.com>
In-Reply-To: <449c43c3@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.20.254.254
Message-ID: <449c47e8@solutions.advantagedatabase.com>
X-Trace: 23 Jun 2006 13:58:32 -0700, 216.20.254.254
Lines: 98
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!216.20.254.254
Xref: solutions.advantagedatabase.com Advantage.Trigger:257
Article PK: 1136324

Thanks Lance, do you happen to know what the error means? I understood
the notes from the help files and I am not the DBA so I will need to
talk to him about raising the number of work areas if needed. I just
wanted to know if there was anything I could do with my code to prevent
this error.

Thanks.

ebn

Lance Schmidt wrote:
> Hi Brent,
>
> From the help files.
>
> Advantage Database Server for NetWare
>
> Problem: The maximum number of configured work areas are already in use.
> Solution: Increase the setting for the WORKAREAS configuration value in the
> Advantage Database Server for NetWare configuration file, ADS.CFG. If no
> WORKAREAS configuration key exists in ADS.CFG, add one and set the value to
> larger than the number of CONNECTIONS multiplied by 25 (which is the default
> value for the number of work areas if no WORKAREAS configuration key
> exists). Then re-load the Advantage Database Server for NetWare.
>
> Advantage Database Server for Windows NT/2000/2003
>
> Problem: The maximum number of configured work areas are already in use.
> Solution: Increase the setting for the "Number of Work Areas" using the
> Advantage Configuration Utility. If you don't wish to use the Advantage
> Configuration Utility, increase the setting for the WORKAREAS configuration
> value in the Advantage Database Server configuration registry key using the
> Registry Editor. The Advantage Database Server Configuration Registry Key is
> located in the Registry at:
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Configuration.
> Then re-start the Advantage Database Server for Windows NT/2000/2003.
>
> Advantage Local Server
>
> Problem: The maximum number of configured work areas are already in use.
> Solution: Increase the setting for the WORKAREAS configuration value in the
> Advantage Local Server configuration file, ADSLOCAL.CFG. If no WORKAREAS
> configuration key exists in ADSLOCAL.CFG, add one and set the value to
> larger than the number of CONNECTIONS multiplied by 25 (which is the default
> value for the number of work areas if no WORKAREAS configuration key
> exists). Then re-start the application that uses the Advantage Local Server.
>
> Best Regards,
>
> Lance Schmidt
> Advantage R&D
>
> "Brent Nelson" <bnelson@westernwats.com> wrote in message
> news:449c3fbe@solutions.advantagedatabase.com...
>> I am using the following trigger:
>>
>> //:======================================================================://
>>
>> DECLARE @compName STRING, @word STRING, @loopCheck LOGICAL;
>> DECLARE newSearchRecordPointer CURSOR;
>> OPEN newSearchRecordPointer AS SELECT * FROM __new;
>> TRY
>> WHILE FETCH newSearchRecordPointer DO
>> @compName = newSearchRecordPointer.c_compName;
>> @loopCheck = true;
>> END WHILE;
>> WHILE @loopCheck = true DO
>> IF LOCATE( ' ', TRIM( @compName ) ) >= 1 THEN
>> @word = TRIM( SUBSTRING( @compName, 1, LOCATE( ' ', @compName ) ) );
>> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( @word );
>> @compName = SUBSTRING( @compName, LOCATE( ' ', @compName ), LENGTH(
>> @compName ) );
>> ELSE
>> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( TRIM(
>> @compName ) );
>> @loopCheck = false;
>> END IF;
>> END WHILE;
>> FINALLY
>> CLOSE newSearchRecordPointer;
>> END TRY;
>>
>> //:======================================================================://
>>
>> But I am getting the following error:
>>
>> Error 7004: Maximum number of work areas exceeded. Table name:
>> searchRecordPointers
>>
>>
>> I am unsure what I can do to fix this. Also, it seems that my trigger runs
>> really slow.
>>
>> Thanks.
>>
>> ebn
>
>


Lance Schmidt Posted on 2006-06-26 22:24:45.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: Advantage.Trigger
References: <449c3fbe@solutions.advantagedatabase.com> <449c43c3@solutions.advantagedatabase.com> <449c47e8@solutions.advantagedatabase.com>
Subject: Re: Error 7004
Date: Mon, 26 Jun 2006 16:24:45 -0600
Lines: 111
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 10.24.38.153
Message-ID: <44a05dd3@solutions.advantagedatabase.com>
X-Trace: 26 Jun 2006 16:21:07 -0700, 10.24.38.153
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.153
Xref: solutions.advantagedatabase.com Advantage.Trigger:258
Article PK: 1136323

Hi Brent,

There is nothing you can do to prevent this error. You have just increase
the number of workareas necessary to complete an update operation.

Best Regards,

Lance Schmidt
Advantage R&D

"Brent Nelson" <bnelson@westernwats.com> wrote in message
news:449c47e8@solutions.advantagedatabase.com...
> Thanks Lance, do you happen to know what the error means? I understood the
> notes from the help files and I am not the DBA so I will need to talk to
> him about raising the number of work areas if needed. I just wanted to
> know if there was anything I could do with my code to prevent this error.
>
> Thanks.
>
> ebn
>
> Lance Schmidt wrote:
>> Hi Brent,
>>
>> From the help files.
>>
>> Advantage Database Server for NetWare
>>
>> Problem: The maximum number of configured work areas are already in use.
>> Solution: Increase the setting for the WORKAREAS configuration value in
>> the Advantage Database Server for NetWare configuration file, ADS.CFG. If
>> no WORKAREAS configuration key exists in ADS.CFG, add one and set the
>> value to larger than the number of CONNECTIONS multiplied by 25 (which is
>> the default value for the number of work areas if no WORKAREAS
>> configuration key exists). Then re-load the Advantage Database Server for
>> NetWare.
>>
>> Advantage Database Server for Windows NT/2000/2003
>>
>> Problem: The maximum number of configured work areas are already in use.
>> Solution: Increase the setting for the "Number of Work Areas" using the
>> Advantage Configuration Utility. If you don't wish to use the Advantage
>> Configuration Utility, increase the setting for the WORKAREAS
>> configuration value in the Advantage Database Server configuration
>> registry key using the Registry Editor. The Advantage Database Server
>> Configuration Registry Key is located in the Registry at:
>> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Configuration.
>> Then re-start the Advantage Database Server for Windows NT/2000/2003.
>>
>> Advantage Local Server
>>
>> Problem: The maximum number of configured work areas are already in use.
>> Solution: Increase the setting for the WORKAREAS configuration value in
>> the Advantage Local Server configuration file, ADSLOCAL.CFG. If no
>> WORKAREAS configuration key exists in ADSLOCAL.CFG, add one and set the
>> value to larger than the number of CONNECTIONS multiplied by 25 (which is
>> the default value for the number of work areas if no WORKAREAS
>> configuration key exists). Then re-start the application that uses the
>> Advantage Local Server.
>>
>> Best Regards,
>>
>> Lance Schmidt
>> Advantage R&D
>>
>> "Brent Nelson" <bnelson@westernwats.com> wrote in message
>> news:449c3fbe@solutions.advantagedatabase.com...
>>> I am using the following trigger:
>>>
>>> //:======================================================================://
>>>
>>> DECLARE @compName STRING, @word STRING, @loopCheck LOGICAL;
>>> DECLARE newSearchRecordPointer CURSOR;
>>> OPEN newSearchRecordPointer AS SELECT * FROM __new;
>>> TRY
>>> WHILE FETCH newSearchRecordPointer DO
>>> @compName = newSearchRecordPointer.c_compName;
>>> @loopCheck = true;
>>> END WHILE;
>>> WHILE @loopCheck = true DO
>>> IF LOCATE( ' ', TRIM( @compName ) ) >= 1 THEN
>>> @word = TRIM( SUBSTRING( @compName, 1, LOCATE( ' ', @compName ) ) );
>>> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( @word );
>>> @compName = SUBSTRING( @compName, LOCATE( ' ', @compName ),
>>> LENGTH( @compName ) );
>>> ELSE
>>> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( TRIM(
>>> @compName ) );
>>> @loopCheck = false;
>>> END IF;
>>> END WHILE;
>>> FINALLY
>>> CLOSE newSearchRecordPointer;
>>> END TRY;
>>>
>>> //:======================================================================://
>>>
>>> But I am getting the following error:
>>>
>>> Error 7004: Maximum number of work areas exceeded. Table name:
>>> searchRecordPointers
>>>
>>>
>>> I am unsure what I can do to fix this. Also, it seems that my trigger
>>> runs really slow.
>>>
>>> Thanks.
>>>
>>> ebn
>>


Paul Man Posted on 2006-06-27 09:18:58.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: Advantage.Trigger
References: <449c3fbe@solutions.advantagedatabase.com> <449c43c3@solutions.advantagedatabase.com>
Subject: Re: Error 7004
Date: Tue, 27 Jun 2006 10:18:58 +0100
Lines: 98
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 82.141.233.142
Message-ID: <44a0f77e@solutions.advantagedatabase.com>
X-Trace: 27 Jun 2006 03:16:46 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Trigger:259
Article PK: 1136325

Why can't the server automatically increase the number of connections and
workareas without intervention? I've seen this a few times with different
people and inevitably everyone puts in huge numbers to guess as adequate
values.

"Lance Schmidt" <LanceSc@ExtendSys.com> wrote in message
news:449c43c3@solutions.advantagedatabase.com...
> Hi Brent,
>
> From the help files.
>
> Advantage Database Server for NetWare
>
> Problem: The maximum number of configured work areas are already in use.
> Solution: Increase the setting for the WORKAREAS configuration value in
> the Advantage Database Server for NetWare configuration file, ADS.CFG. If
> no WORKAREAS configuration key exists in ADS.CFG, add one and set the
> value to larger than the number of CONNECTIONS multiplied by 25 (which is
> the default value for the number of work areas if no WORKAREAS
> configuration key exists). Then re-load the Advantage Database Server for
> NetWare.
>
> Advantage Database Server for Windows NT/2000/2003
>
> Problem: The maximum number of configured work areas are already in use.
> Solution: Increase the setting for the "Number of Work Areas" using the
> Advantage Configuration Utility. If you don't wish to use the Advantage
> Configuration Utility, increase the setting for the WORKAREAS
> configuration value in the Advantage Database Server configuration
> registry key using the Registry Editor. The Advantage Database Server
> Configuration Registry Key is located in the Registry at:
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Configuration.
> Then re-start the Advantage Database Server for Windows NT/2000/2003.
>
> Advantage Local Server
>
> Problem: The maximum number of configured work areas are already in use.
> Solution: Increase the setting for the WORKAREAS configuration value in
> the Advantage Local Server configuration file, ADSLOCAL.CFG. If no
> WORKAREAS configuration key exists in ADSLOCAL.CFG, add one and set the
> value to larger than the number of CONNECTIONS multiplied by 25 (which is
> the default value for the number of work areas if no WORKAREAS
> configuration key exists). Then re-start the application that uses the
> Advantage Local Server.
>
> Best Regards,
>
> Lance Schmidt
> Advantage R&D
>
> "Brent Nelson" <bnelson@westernwats.com> wrote in message
> news:449c3fbe@solutions.advantagedatabase.com...
>>I am using the following trigger:
>>
>> //:======================================================================://
>>
>> DECLARE @compName STRING, @word STRING, @loopCheck LOGICAL;
>> DECLARE newSearchRecordPointer CURSOR;
>> OPEN newSearchRecordPointer AS SELECT * FROM __new;
>> TRY
>> WHILE FETCH newSearchRecordPointer DO
>> @compName = newSearchRecordPointer.c_compName;
>> @loopCheck = true;
>> END WHILE;
>> WHILE @loopCheck = true DO
>> IF LOCATE( ' ', TRIM( @compName ) ) >= 1 THEN
>> @word = TRIM( SUBSTRING( @compName, 1, LOCATE( ' ', @compName ) ) );
>> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( @word );
>> @compName = SUBSTRING( @compName, LOCATE( ' ', @compName ), LENGTH(
>> @compName ) );
>> ELSE
>> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( TRIM(
>> @compName ) );
>> @loopCheck = false;
>> END IF;
>> END WHILE;
>> FINALLY
>> CLOSE newSearchRecordPointer;
>> END TRY;
>>
>> //:======================================================================://
>>
>> But I am getting the following error:
>>
>> Error 7004: Maximum number of work areas exceeded. Table name:
>> searchRecordPointers
>>
>>
>> I am unsure what I can do to fix this. Also, it seems that my trigger
>> runs really slow.
>>
>> Thanks.
>>
>> ebn
>
>


Jeremy Mullin Posted on 2006-06-27 13:59:49.0Z
Date: Tue, 27 Jun 2006 13:59:49 +0000 (UTC)
Message-ID: <886edc15146c88c867d6cc409754@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: Error 7004
Newsgroups: Advantage.Trigger
References: <44a0f77e@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 928.2
NNTP-Posting-Host: 10.24.38.116
X-Trace: 27 Jun 2006 07:56:10 -0700, 10.24.38.116
Lines: 107
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.116
Xref: solutions.advantagedatabase.com Advantage.Trigger:260
Article PK: 1136326

For legacy reasons. I'll add a customer suggestion to change this behavior
to be dynamic.

J.D. Mullin
Advantage R&D

> Why can't the server automatically increase the number of connections
> and workareas without intervention? I've seen this a few times with
> different people and inevitably everyone puts in huge numbers to guess
> as adequate values.
>
> "Lance Schmidt" <LanceSc@ExtendSys.com> wrote in message
> news:449c43c3@solutions.advantagedatabase.com...
>
>> Hi Brent,
>>
>> From the help files.
>>
>> Advantage Database Server for NetWare
>>
>> Problem: The maximum number of configured work areas are already in
>> use. Solution: Increase the setting for the WORKAREAS configuration
>> value in the Advantage Database Server for NetWare configuration
>> file, ADS.CFG. If no WORKAREAS configuration key exists in ADS.CFG,
>> add one and set the value to larger than the number of CONNECTIONS
>> multiplied by 25 (which is the default value for the number of work
>> areas if no WORKAREAS configuration key exists). Then re-load the
>> Advantage Database Server for NetWare.
>>
>> Advantage Database Server for Windows NT/2000/2003
>>
>> Problem: The maximum number of configured work areas are already in
>> use.
>> Solution: Increase the setting for the "Number of Work Areas" using
>> the
>> Advantage Configuration Utility. If you don't wish to use the
>> Advantage
>> Configuration Utility, increase the setting for the WORKAREAS
>> configuration value in the Advantage Database Server configuration
>> registry key using the Registry Editor. The Advantage Database Server
>> Configuration Registry Key is located in the Registry at:
>> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Config
>> uration.
>> Then re-start the Advantage Database Server for Windows NT/2000/2003.
>> Advantage Local Server
>>
>> Problem: The maximum number of configured work areas are already in
>> use. Solution: Increase the setting for the WORKAREAS configuration
>> value in the Advantage Local Server configuration file, ADSLOCAL.CFG.
>> If no WORKAREAS configuration key exists in ADSLOCAL.CFG, add one and
>> set the value to larger than the number of CONNECTIONS multiplied by
>> 25 (which is the default value for the number of work areas if no
>> WORKAREAS configuration key exists). Then re-start the application
>> that uses the Advantage Local Server.
>>
>> Best Regards,
>>
>> Lance Schmidt
>> Advantage R&D
>> "Brent Nelson" <bnelson@westernwats.com> wrote in message
>> news:449c3fbe@solutions.advantagedatabase.com...
>>
>>> I am using the following trigger:
>>>
>>> //:=================================================================
>>> =====://
>>>
>>> DECLARE @compName STRING, @word STRING, @loopCheck LOGICAL;
>>> DECLARE newSearchRecordPointer CURSOR;
>>> OPEN newSearchRecordPointer AS SELECT * FROM __new;
>>> TRY
>>> WHILE FETCH newSearchRecordPointer DO
>>> @compName = newSearchRecordPointer.c_compName;
>>> @loopCheck = true;
>>> END WHILE;
>>> WHILE @loopCheck = true DO
>>> IF LOCATE( ' ', TRIM( @compName ) ) >= 1 THEN
>>> @word = TRIM( SUBSTRING( @compName, 1, LOCATE( ' ', @compName ) ) );
>>> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( @word );
>>> @compName = SUBSTRING( @compName, LOCATE( ' ', @compName ), LENGTH(
>>> @compName ) );
>>> ELSE
>>> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( TRIM(
>>> @compName ) );
>>> @loopCheck = false;
>>> END IF;
>>> END WHILE;
>>> FINALLY
>>> CLOSE newSearchRecordPointer;
>>> END TRY;
>>> //:=================================================================
>>> =====://
>>>
>>> But I am getting the following error:
>>>
>>> Error 7004: Maximum number of work areas exceeded. Table name:
>>> searchRecordPointers
>>>
>>> I am unsure what I can do to fix this. Also, it seems that my
>>> trigger runs really slow.
>>>
>>> Thanks.
>>>
>>> ebn
>>>


Paul Man Posted on 2006-07-07 13:38:26.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: Advantage.Trigger
References: <44a0f77e@solutions.advantagedatabase.com> <886edc15146c88c867d6cc409754@devzone.advantagedatabase.com>
Subject: Re: Error 7004
Date: Fri, 7 Jul 2006 14:38:26 +0100
Lines: 114
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 82.141.233.142
Message-ID: <44ae6352@solutions.advantagedatabase.com>
X-Trace: 7 Jul 2006 07:36:18 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Trigger:261
Article PK: 1136327

I hope it gets changed as no doubt it inconveniences both customers and
ourselves trying to guess what is required.

"Jeremy Mullin" <no@email.com> wrote in message
news:886edc15146c88c867d6cc409754@devzone.advantagedatabase.com...
> For legacy reasons. I'll add a customer suggestion to change this behavior
> to be dynamic.
>
> J.D. Mullin
> Advantage R&D
>
>> Why can't the server automatically increase the number of connections
>> and workareas without intervention? I've seen this a few times with
>> different people and inevitably everyone puts in huge numbers to guess
>> as adequate values.
>>
>> "Lance Schmidt" <LanceSc@ExtendSys.com> wrote in message
>> news:449c43c3@solutions.advantagedatabase.com...
>>
>>> Hi Brent,
>>>
>>> From the help files.
>>>
>>> Advantage Database Server for NetWare
>>>
>>> Problem: The maximum number of configured work areas are already in
>>> use. Solution: Increase the setting for the WORKAREAS configuration
>>> value in the Advantage Database Server for NetWare configuration
>>> file, ADS.CFG. If no WORKAREAS configuration key exists in ADS.CFG,
>>> add one and set the value to larger than the number of CONNECTIONS
>>> multiplied by 25 (which is the default value for the number of work
>>> areas if no WORKAREAS configuration key exists). Then re-load the
>>> Advantage Database Server for NetWare.
>>>
>>> Advantage Database Server for Windows NT/2000/2003
>>>
>>> Problem: The maximum number of configured work areas are already in
>>> use.
>>> Solution: Increase the setting for the "Number of Work Areas" using
>>> the
>>> Advantage Configuration Utility. If you don't wish to use the
>>> Advantage
>>> Configuration Utility, increase the setting for the WORKAREAS
>>> configuration value in the Advantage Database Server configuration
>>> registry key using the Registry Editor. The Advantage Database Server
>>> Configuration Registry Key is located in the Registry at:
>>> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Config
>>> uration.
>>> Then re-start the Advantage Database Server for Windows NT/2000/2003.
>>> Advantage Local Server
>>>
>>> Problem: The maximum number of configured work areas are already in
>>> use. Solution: Increase the setting for the WORKAREAS configuration
>>> value in the Advantage Local Server configuration file, ADSLOCAL.CFG.
>>> If no WORKAREAS configuration key exists in ADSLOCAL.CFG, add one and
>>> set the value to larger than the number of CONNECTIONS multiplied by
>>> 25 (which is the default value for the number of work areas if no
>>> WORKAREAS configuration key exists). Then re-start the application
>>> that uses the Advantage Local Server.
>>>
>>> Best Regards,
>>>
>>> Lance Schmidt
>>> Advantage R&D
>>> "Brent Nelson" <bnelson@westernwats.com> wrote in message
>>> news:449c3fbe@solutions.advantagedatabase.com...
>>>
>>>> I am using the following trigger:
>>>>
>>>> //:=================================================================
>>>> =====://
>>>>
>>>> DECLARE @compName STRING, @word STRING, @loopCheck LOGICAL;
>>>> DECLARE newSearchRecordPointer CURSOR;
>>>> OPEN newSearchRecordPointer AS SELECT * FROM __new;
>>>> TRY
>>>> WHILE FETCH newSearchRecordPointer DO
>>>> @compName = newSearchRecordPointer.c_compName;
>>>> @loopCheck = true;
>>>> END WHILE;
>>>> WHILE @loopCheck = true DO
>>>> IF LOCATE( ' ', TRIM( @compName ) ) >= 1 THEN
>>>> @word = TRIM( SUBSTRING( @compName, 1, LOCATE( ' ', @compName ) ) );
>>>> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( @word );
>>>> @compName = SUBSTRING( @compName, LOCATE( ' ', @compName ), LENGTH(
>>>> @compName ) );
>>>> ELSE
>>>> INSERT INTO searchRecordPointers ( srp_pointer ) VALUES ( TRIM(
>>>> @compName ) );
>>>> @loopCheck = false;
>>>> END IF;
>>>> END WHILE;
>>>> FINALLY
>>>> CLOSE newSearchRecordPointer;
>>>> END TRY;
>>>> //:=================================================================
>>>> =====://
>>>>
>>>> But I am getting the following error:
>>>>
>>>> Error 7004: Maximum number of work areas exceeded. Table name:
>>>> searchRecordPointers
>>>>
>>>> I am unsure what I can do to fix this. Also, it seems that my
>>>> trigger runs really slow.
>>>>
>>>> Thanks.
>>>>
>>>> ebn
>>>>
>
>