agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Error during Adempiere data base import using PL/Java
3+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Error during Adempiere data base import using PL/Java
@ 2008-05-08 13:05
2008-05-08 18:12 ` [Pljava-dev] Error during Adempiere data base import using PL/Java
0 siblings, 1 reply; 3+ messages in thread
From: @ 2008-05-08 13:05 UTC (permalink / raw)
Dear forum members,
I install Adempiere_340s.tar on the following system:
OpenSUSE 10.2 (32bit)
PostgreSQL 8.1.11 i586
Java-1-6-0-sun 1.6.0 i586
PL/Java package: pljava-i686-pc-linux-gnu-pg8.1-1.4.0
During import process of the Database dump I get the error messages below:
...
SET
psql:/usr/Adempiere/data/Adempiere_pg.dmp:6: ERROR: Parameter
?standard_conforming_strings? cannot be changed
SET
SET
SET
CREATE SCHEMA
ALTER SCHEMA
COMMENT
CREATE SCHEMA
...
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648: ERROR: Error
?Syntaxerror? by ?OWNED? at character 38
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648: LINE 1: ALTER
SEQUENCE jar_entry_entryid_seq OWNED BY jar_entry.entr...
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648:
^
setval
--------
10
(1 row)
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20691: ERROR: Error
?Syntaxerror? by ?OWNED? at character 41
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20691: LINE 1: ALTER
SEQUENCE jar_repository_jarid_seq OWNED BY jar_reposit...
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20691:
^
setval
--------
1
(1 row)
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20732: ERROR: Error
?Syntaxerror? by ?OWNED? at character 40
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20732: LINE 1: ALTER
SEQUENCE typemap_entry_mapid_seq OWNED BY typemap_entr...
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20732:
^
setval
--------
1
(1 row)
ALTER TABLE
ALTER TABLE
...
Regarding the first error I have found inside the PostgreSQL 8.2.7
documentation the description below. Can anybody tell me where I can
make this parameter
changeable? I did'nt find it in the postgresql.conf.
Chapter 17. Server Configuration
17.12. Version and Platform Compatibility
17.12.1. Previous PostgreSQL Versions
standard_conforming_strings (boolean)
This controls whether ordinary string literals ('...') treat
backslashes literally, as specified in the SQL standard. The default
is currently off, causing
PostgreSQL to have its historical behavior of treating backslashes as
escape characters. The default will change to on in a future release
to improve
compatibility with the standard. Applications may check this parameter
to determine how string literals will be processed. The presence of
this parameter can
also be taken as an indication that the escape string syntax (E'...')
is supported. Escape string syntax should be used if an application
desires backslashes
to be treated as escape characters.
Regarding the other three errors I would appreciate if anybody can
tell me if its a problem either with my PL/Java installation or an
issue of Adempiere. Maybe somebody has also an idea how I can fix it
;o)
Thanks in advance,
Hawky
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Error during Adempiere data base import using PL/Java
2008-05-08 13:05 [Pljava-dev] Error during Adempiere data base import using PL/Java
@ 2008-05-08 18:12 `
2008-05-12 18:11 ` [Pljava-dev] Error during Adempiere data base import using PL/Java
0 siblings, 1 reply; 3+ messages in thread
From: @ 2008-05-08 18:12 UTC (permalink / raw)
Hauke Luckow wrote:
> Dear forum members,
> I install Adempiere_340s.tar on the following system:
>
> PostgreSQL 8.1.11 i586
>
> During import process of the Database dump I get the error messages below:
>
> psql:/usr/Adempiere/data/Adempiere_pg.dmp:6: ERROR: Parameter
> ?standard_conforming_strings? cannot be changed
> psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648: ERROR: Error
> ?Syntaxerror? by ?OWNED? at character 38
The Adempiere dump you are trying to load was created on a newer server
version. Dump files cannot be loaded into older server versions than
they were created on. You'll need to upgrade or find another dump file
created for your server version.
Kris Jurka
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Error during Adempiere data base import using PL/Java
2008-05-08 13:05 [Pljava-dev] Error during Adempiere data base import using PL/Java
2008-05-08 18:12 ` [Pljava-dev] Error during Adempiere data base import using PL/Java
@ 2008-05-12 18:11 `
0 siblings, 0 replies; 3+ messages in thread
From: @ 2008-05-12 18:11 UTC (permalink / raw)
2008/5/8 Kris Jurka <books at ejurka.com>:
> Hauke Luckow wrote:
>
> > Dear forum members,
> > I install Adempiere_340s.tar on the following system:
> >
> > PostgreSQL 8.1.11 i586
> >
> > During import process of the Database dump I get the error messages
> > below:
> >
> > psql:/usr/Adempiere/data/Adempiere_pg.dmp:6: ERROR: Parameter
> > ?standard_conforming_strings? cannot be changed
> >
> > psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648: ERROR: Error
> > ?Syntaxerror? by ?OWNED? at character 38
>
>
> The Adempiere dump you are trying to load was created on a newer server
> version. Dump files cannot be loaded into older server versions than they
> were created on. You'll need to upgrade or find another dump file created
> for your server version.
>
> Kris Jurka
>
> Thank you very much, Kris even though its not an PL/Java issue.
Sorry to answer just now but first I wanted to try it out and post the
success.
I updated from OpenSuse 10.2 to 10.3 and thereby from Postgresql 8.1.11 to
8.2.4
After that I updated from Postgresql 8.2.4 to 8.2.6
Also I needed now an upgrade of PL/Java 1.4.0 for Postgresql 8.2.6+
Now import of Adempiere dump was no problem and without any error or warning
messages.
Thanks again for your help,
Hawky
then
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080512/45517daf/attachment.html;
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-05-12 18:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-05-08 13:05 [Pljava-dev] Error during Adempiere data base import using PL/Java
2008-05-08 18:12 `
2008-05-12 18:11 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox