Latest topics for the forum "Tuning and Migration Wizard"

unable to run the query

Srikanth_Kata_2 — GMT

select s.*,a.actid,a.phone,d.domid,d.domname,d.domno,a.actno,a.actname,p.descr as svcdescr
from vwsubsmin s
inner join packages p on s.svcno=p.pkgno
inner join account a on a.actno=s.actno
inner join ssgdom d on a.domno=d.domno
inner join (select subsno from getexpiringsubs($1,cast($2 as integer),cast($3 as double precision),$4) as (subsno int,expirydt timestamp without time zone,balcpt double precision)) as e
on s.subsno=e.subsno where s.status <=15 and d.domno=$5 order by d.domname,s.expirydt,a.actname

When i run this query i am facing the following error:

ERROR: there is no parameter $1
LINE 3: ...no inner join (select subsno from getexpiringsubs($1,cast($2...
^

********** Error **********

ERROR: there is no parameter $1
SQL state: 42P02
Character: 277

Please let me know the issue on srikanth@inventum.net

pg_restore problem: extra data after last expected column

Federico_Belotti — GMT

Dear All,

I've the same problem with postgreSQL 8.4. When I try to restore a .backup file created with pg_dump (by using the pg_restore procedure)
I get the error "Extra data after last expected column". I suspect that is a problem of encoding or delimiters. Can you help me?

here is the log:

2010-06-18 17:13:19 CEST ERROR: language "plpgsql" already exists
2010-06-18 17:13:19 CEST STATEMENT:
CREATE PROCEDURAL LANGUAGE plpgsql;
2010-06-18 17:24:26 CEST ERROR: extra data after last expected column
2010-06-18 17:24:26 CEST CONTEXT: COPY cart_accert, line 3084737: "\N N \N \N \N 0 785 \\N N \N \N \N41-21 100oRI\N \N 0 2952 MW67J@Y9[WER¶ 2000-01-25 2000-02-11 1..."
2010-06-18 17:24:26 CEST STATEMENT: COPY cart_accert (num_ese, ac_prn, ac_prezzo, ac_query, stampato, ac_out, ac_paga, ac_scad, ac_ripe, ac_code, ac_nt_code, ac_nt_fonte, ac_norma, ac_um, indotto, cod_ese, codificato, codice, data_open, data_upd, time_last, rowid, ora, userid, pb_code, ac_des, ac_val, ac_mem, ac_ese, ac_tipo, euro, rowid_master, ur_pb_id, data_richiesta, evidenza_referto, ritornato) FROM stdin;
2010-06-18 17:24:26 CEST LOG: could not send data to client: No connection could be made because the target machine actively refused it.

2010-06-18 17:24:26 CEST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.

2010-06-18 17:24:26 CEST LOG: incomplete message from client

Many thanks,

Federico

MySQL to Postgres Migration Wizard by EnterpriseDB v1.1

baloney — GMT

Hi Guys,
I downloaded this archive but I have no idea what I'm supposed to do with it. No readme file,
nothing that looks like an executable, can someone point me in the right direction please?

Migration Oracle to EnterpriseDB function sys_context

Bendy_Damen — GMT

Recently started experimenting with EDB trying to migrate our oracle db.
The import failes for a big part due to the function 'sys_context("unknown", "unknown") does not exist'
Anyone care to share the solution or point me in the direction.

Database wont Start after Tuning Wizard

Julius_Petzholdt — GMT

Hey there!

I am running PostgreSQL 8.4 on a dedicatet Server (OS: Windows Web Server 2008 R2)

I installed the Tuning Wizard, and ran it, chosing the "dedicated" Option.
After Replacing the Original "postgesql.conf" file, the SQL Server wont start, just times out.

Any Ideas, or known problems?

Kind Regards

Julius

P.S: The Server has plenty power, and I need to bulk load a big Database (~2TB), which would be quite annoying, if I had to do that with the default "slow" settings.

MS-SQL to Advanced Server

Pete_Halsted — GMT

We are working on migrating from MS-SQL to Postgres Advanced. We are using the Migration studio to attempt to convert the Schema and data. Schema is coming over but we have several tables that are giving us encoding errors (see below). We can't figure out the right combination of setting to resolve the issue.

The other issue we have is with the delimiter character we have a few tables that contain | characters. In fact all 127 of the Basic ASC chart are represented in our data, and my first attempt at using extended ascii characters above 127 didn't seem to work either. Any suggestions on what character to use?

Thanks
Pete Halsted
JK Harris
636-432-9339

First error:
Loading Table: prospect ...
Error Loading Data into Table: outboundcustomer: ERROR: invalid byte sequence for encoding "UTF8": 0xd13f
Hint: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
Where: COPY outboundcustomer, line 865

Then when it completes all tables in first pass we get:
Trying to reload table: outboundcustomer through bulk inserts with a batch size of 1000
ERROR: character 0xefbfbd of encoding "UTF8" has no equivalent in "WIN1252", Skipping Batch

MySQL migration wizard

Andrej_Ricnik — GMT

Hi,

I was wondering where I can find installation/build instructions. A simple make fails
because the PATH to the wx includes on my system differs from /usr/include/wx

Cheers,
Andrej

Tuning Wizard account problem

Chris_Schra — GMT

Hi,

I'm trying to install Tuning Wizard for Postgre 8.4.

I've created an enterprisedb.com account and be able to log in onto your site. But if I try to use my account details during the installation process, I always get the following error msg:

"Error in calling web service. Please check the internet connection and try again."

System: Windows 7 64bit
Firewall: Windows firewall off, basic router firewall on

It would be great, if somebody can help...

Regards,
Chris

problem with autovacuum processes

Venkat_B — GMT

Hi,

We are using PostgreSQL 8.3.7 version and our DB size is around 200GB and its OLTP database. We are having partition tables and maintains for 120 days data.

But from couple of days we are getting the processes slow down and i noticed the following processes like:
procpid | usename | query_start | run_time | waiting | current_query
---------+----------+---------------------+-----------------+---------+---------------------------------------------------------------------------------------------------------------------
14971 | postgres | 2009-11-07 16:17:49 | 5 days 13:15:51 | f | autovacuum: VACUUM test.tr_td_dimension_2009_08_21 (to prevent wraparound)
19674 | postgres | 2009-11-11 09:43:15 | 1 day 19:50:25 | f | autovacuum: VACUUM test.tr_stg_hr_dimension_2009_08_18 (to prevent wraparound)
28064 | postgres | 2009-11-10 12:26:26 | 2 days 17:07:14 | f | autovacuum: VACUUM test.tr_td_dimension_2009_08_18 (to prevent wraparound)
17044 | postgres | 2009-11-12 17:03:06 | 12:30:34 | f | autovacuum: VACUUM ANALYZE test.dn_rule_data (to prevent wraparound)
25602 | postgres | 2009-11-11 22:12:49 | 1 day 07:20:51 | f | autovacuum: VACUUM test.tr_td_dimension_2009_08_02 (to prevent wraparound)

We enabled autovacuum for every 2million records.... but these processes are runnning for days and which is causing for the partition tables creation and delinking failures and also the drastic performance failure.

Is there any way where we can reduce the time of running of these autovacuum processes.

--Venkat

Oracle to Postgres Migration

Bhanu_Prasad — GMT

I have found some issue with Migrating Oracle XML Type objects. Can any one help in finding an alternative solution for XML type Procedures migration to Postgres. Nearly 50% of Procedures are used XML type.

Migration tool missing varbinary

jeroen.kleijer@cvis.nl — GMT

I'm trying to convert a database from MySQL to PostgresPlus using the Migration Toolkit but it's currently failed due to the lack of varbinary support causing some tables to go missing.
Would it be possible to extend the MTK with an option field or something that allows someone to tell the MTK "If you see this type, and you don't support it yet, replace it with this type." (such as doing so with varbinary and replacing it with bytea)
Would such a thing be possible?

Regards,

Jeroen Kleijer

Oracle migration problem.

IoaN_Bah — GMT

Hello, I have an interesting issue when I migrate my database from Oracle 10 to enterpriseDB.
The database migration tool refuse to migrate the packages that have " ... IS NUMBER ..." in their descriptions.
For example for the package that begins with:

CREATE OR REPLACE PACKAGE Force_to_Finish AS
TYPE t_return IS REF CURSOR;
SUBTYPE t_number IS NUMBER;
...

migration tool says:

Creating Package: FORCE_TO_FINISH
Error Creating Package Spec FORCE_TO_FINISH: ERROR: syntax error at or near "IS" at position 89
; SUBTYPE t_number IS NUMBER
^

Can anyone help me with this problem?
Thanks.

MySQL database and cloud computing

Tom_T — GMT

Hi all,

We are a young, new company on the market. We are starting to open up new markets in other countries (Europe).

It somewhat is a challenge for us: we can't share our data and mysql database between all our different services. So here is my question: do you think it would be possible to find an ETL program that could work in the cloud?

It would not have to be too complex, but sturdy and working as a Software as a Service.

Thanks a lot for your help.

Training on an ETL tool

Tom_T — GMT

Hi all,

We are in the process of getting an ETL program. We need it to perform some basic extract, transform and load jobs.
But we want to get an open source tool with good training.
Our team is mainly business oriented, with some computer knowledge. We would like to have someone come to our company and explain to all the team how to operate the tool.

I can operate the tool on my own, but I am not experienced enough to show other people how to operate the software.
So would someone know which open source companies offer ETL tools with good training and how much time would it take?

Thanks.

MySQL Migration Wizard (Migrator) Blank Dialog

charles.grindel@incentivetargeting.com — GMT

Hi,

I installed PostgresPlus 8.3 on Ubuntu 9.04 (Jaunty Jackalope) and wanted to try out the MySQL migration wizard. However, when I launch the wizard, a dialog appears with the title "MySQL to Postgres Migrator by EnterpriseDB", but the rest of the dialog is blank. When I click the X to close the window, I do see a confirmation dialog asking if I really want to exit. The contents of the confirmation dialog appear correctly. Has anyone seen this or have any ideas?

I tried uninstalling and installing PostgresPlus, but that did not fix the problem. I thought that I might be using an old version of Java, but it appears that I am running the latest.

$ java -version
java version "1.6.0_14"
Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
Java HotSpot(TM) 64-Bit Server VM (build 14.0-b16, mixed mode)

pgAdmin III works and I am able to connect to the newly installed database server.

One last note, I do have postgresql (from repositories) and PostgresPlus installed. The postgres server is listening on port 5432 and the PostgresPlus server is listening on 5433. I doubt that this is causing the problem, but I thought that I would mention it.

Thanks,
Chuck