![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 9 of 9 total |
![]() |
Wed, Nov 21 2007 5:48 AM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 AM | Permanent 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 AM | Permanent 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 Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |