Elevate Software

Login Login

ProductsBulletSalesBulletSupportBulletDownloadsBulletAbout



Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread

Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread Job Error 9999
Wed, Nov 21 2007 5:48 AMPermanent Link

"Jochem Stemmermann"
Hi,

this job:



BEGIN

use Sarakalib;

execute immediate 'drop table debitor';

EXECUTE IMMEDIATE 'CREATE TABLE "Debitor"

                    (

                    "Kundennr" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "Name1" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "Name2" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "Name3" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "Adresse1" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "Adresse2" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "Land" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "PLZ" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "Ort" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "Telefom" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "Fax" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL,

                    "Code" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''

                      NOT NULL

                    )

                    VERSION 1

                    UNENCRYPTED

                    INDEX PAGE SIZE 4096

                    BLOB BLOCK SIZE 512

                    MAX ROW BUFFER SIZE 32768

                    MAX INDEX BUFFER SIZE 65536

                    MAX BLOB BUFFER SIZE 32768';



  execute immediate 'IMPORT TABLE Debitor

                     FROM ''c:\debitor.txt''

                     DELIMITER CHAR ''|''

                     USE HEADERS';



  EXECUTE IMMEDIATE 'CREATE INDEX "ixKundenr" ON "Debitor"

                    ("Kundennr" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ixName1" ON "Debitor"

                    ("Name1" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ixName2" ON "Debitor"

                    ("Name2" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ixName3" ON "Debitor"

                    ("Name3" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ixOrt" ON "Debitor"

                    ("Ort" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ixPlz" ON "Debitor"

                    ("PLZ" COLLATE "ANSI_CI")';

  EXECUTE IMMEDIATE 'CREATE INDEX "ixSuchen" ON "Debitor"

                    ("Kundennr" COLLATE "ANSI_CI", "Name1" COLLATE
"ANSI_CI", "Name2" COLLATE "ANSI_CI", "Name3" COLLATE "ANSI_CI", "Ort"
COLLATE "ANSI_CI")';

END



return error 9999 :

Access violation at address 0054524D in module 'edbsrvr.exe'. Read of
address 00000000



this code as script -> the same error



Any suggestions appreciated

regards
Jochem

Wed, Nov 21 2007 5:52 AMPermanent Link

"Jochem Stemmermann"
the same code as procedure run without any error
"Jochem Stemmermann" <Jochem.Stemmermann@Sartorius-Werkzeuge.de> schrieb im
Newsbeitrag
news:533DEE03-58CB-4BB0-89BD-2CB3BFFEF278@news.elevatesoft.com...
> Hi,
>
> this job:
>
>
>
> BEGIN
>
> use Sarakalib;
>
> execute immediate 'drop table debitor';
>
> EXECUTE IMMEDIATE 'CREATE TABLE "Debitor"
>
>                     (
>
>                     "Kundennr" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "Name1" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "Name2" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "Name3" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "Adresse1" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "Adresse2" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "Land" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "PLZ" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "Ort" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "Telefom" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "Fax" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL,
>
>                     "Code" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' ''
>
>                       NOT NULL
>
>                     )
>
>                     VERSION 1
>
>                     UNENCRYPTED
>
>                     INDEX PAGE SIZE 4096
>
>                     BLOB BLOCK SIZE 512
>
>                     MAX ROW BUFFER SIZE 32768
>
>                     MAX INDEX BUFFER SIZE 65536
>
>                     MAX BLOB BUFFER SIZE 32768';
>
>
>
>   execute immediate 'IMPORT TABLE Debitor
>
>                      FROM ''c:\debitor.txt''
>
>                      DELIMITER CHAR ''|''
>
>                      USE HEADERS';
>
>
>
>   EXECUTE IMMEDIATE 'CREATE INDEX "ixKundenr" ON "Debitor"
>
>                     ("Kundennr" COLLATE "ANSI_CI")';
>
>   EXECUTE IMMEDIATE 'CREATE INDEX "ixName1" ON "Debitor"
>
>                     ("Name1" COLLATE "ANSI_CI")';
>
>   EXECUTE IMMEDIATE 'CREATE INDEX "ixName2" ON "Debitor"
>
>                     ("Name2" COLLATE "ANSI_CI")';
>
>   EXECUTE IMMEDIATE 'CREATE INDEX "ixName3" ON "Debitor"
>
>                     ("Name3" COLLATE "ANSI_CI")';
>
>   EXECUTE IMMEDIATE 'CREATE INDEX "ixOrt" ON "Debitor"
>
>                     ("Ort" COLLATE "ANSI_CI")';
>
>   EXECUTE IMMEDIATE 'CREATE INDEX "ixPlz" ON "Debitor"
>
>                     ("PLZ" COLLATE "ANSI_CI")';
>
>   EXECUTE IMMEDIATE 'CREATE INDEX "ixSuchen" ON "Debitor"
>
>                     ("Kundennr" COLLATE "ANSI_CI", "Name1" COLLATE
> "ANSI_CI", "Name2" COLLATE "ANSI_CI", "Name3" COLLATE "ANSI_CI", "Ort"
> COLLATE "ANSI_CI")';
>
> END
>
>
>
> return error 9999 :
>
> Access violation at address 0054524D in module 'edbsrvr.exe'. Read of
> address 00000000
>
>
>
> this code as script -> the same error
>
>
>
> Any suggestions appreciated
>
> regards
> Jochem
>
>

Wed, Nov 21 2007 10:47 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jochem,

<< this job: >>

I'm not seeing an AV here when running it as a script, but I am getting a
write lock error due to the USE statement.  There is a lock issue there that
needs to be corrected for 1.06 B2.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Nov 21 2007 10:57 AMPermanent Link

"Jochem Stemmermann"
thanks for the information.

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schrieb im
Newsbeitrag
news:FCE53F5C-7FB4-4C44-8130-0BFD6D29DA1A@news.elevatesoft.com...
> Jochem,
>
> << this job: >>
>
> I'm not seeing an AV here when running it as a script, but I am getting a
> write lock error due to the USE statement.  There is a lock issue there
> that needs to be corrected for 1.06 B2.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Wed, Jan 2 2008 4:17 AMPermanent Link

Jochem Stemmermann
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Jochem,

<< this job: >>

I'm not seeing an AV here when running it as a script, but I am getting a
write lock error due to the USE statement.  There is a lock issue there that
needs to be corrected for 1.06 B2.

--
Tim Young
Elevate Software
www.elevatesoft.com

At first, a happy new year.
The same error in 1.07!
Wed, Jan 2 2008 4:03 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jochem,

<< The same error in 1.07! >>

Which error - the AV or the lock error ?  As I indicated before, I could
never reproduce the AV error.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Jan 3 2008 3:38 AMPermanent Link

Jochem Stemmermann
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Jochem,

<< The same error in 1.07! >>

Which error - the AV or the lock error ?  As I indicated before, I could
never reproduce the AV error.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi, Tim

when it runs as JOB this error :
Access violation at address 0054844A in module 'edbsrvr.exe'. Read of address 00000000

Fri, Jan 4 2008 7:59 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jochem,

<< when it runs as JOB this error :
Access violation at address 0054844A in module 'edbsrvr.exe'. Read of
address 00000000 >>

Can you send me your EDBConfig.edbcfg file that contains the job definition
?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Jan 4 2008 9:51 AMPermanent Link

Jochem Stemmermann
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Jochem,

<< when it runs as JOB this error :
Access violation at address 0054844A in module 'edbsrvr.exe'. Read of
address 00000000 >>

Can you send me your EDBConfig.edbcfg file that contains the job definition
?

Thanks,

--
Here we come...
Tim Young
Elevate Software
www.elevatesoft.com



Attachments: Sartorius.EDBCfg


This web page was last updated on
Tuesday, April 30, 2024 at 03:55 PM

Privacy PolicyBulletSite Map

© 2024 Elevate Software, Inc. All Rights Reserved
Questions or comments ? E-mail E-mail us at info@elevatesoft.com

Image