Search Postgresql Archives

Re: Bind Parameter is Too Big

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 9/1/22 1:34 PM, Kluzak, Matthew C. wrote:
I support a system where staff use a PowerBuilder 2019R3 app that enters data into a Postgres 12 database, generates SQL statements for the data and saves them as text files. Staff uses another PB2019R3 app to populate a Sybase ASE 15.7 database with the generated SQL statement files. Other staff then uses a PB2019R3 app to pipe the data to a master Sybase ASE 15.7 database. At the beginning of each week that data is piped via PB2019R3 app to another Sybase ASE 15.7 database. The inspectors then update their Postgres database with all inspectors' data via another PB2019R3 app that pipes the data from Sybase to Postgres.

  * Yes, I understand how absurd the system is. I just inherited it and
    am supporting it until we can replace it.

The .gov domain was explanation enough.

However, when trying to pipe the data from Sybase to Postgres I get the error "Bind Parameter for value :9 is Too Big (2000)." The comment column is the 9th column.

I checked the data and verified it isn't over the 1000 character limit. I tried deleting out 13 of the 1000 characters, and the error this time was "Bind Parameter for value :9 is Too Big (1976)."

What is the actual code that pipes the data?

What is the encoding/character set in Sybase vs Postgres?


Via Appeon’s support forums I worked out getting the pipe to work in the PowerBuilder IDE by enabling staticbind and disablebind. In this view, I can get a connection string to use in the app’s configuration file. However, using this connection string in the app’s configuration file still doesn’t work when running the pipe in the app.

Connection string is: DBParm=ConnectString='DSN=WM_LT_User;UID=user;PWD=password',PBCatalogOwner='user',DelimitIdentifier='Yes',DisableBind=1

Appeon is claiming it is a Postgres issue and so I am inquiring here. I am hoping someone can help steer me in the right direction to get this pipe working.

Thanks

Matt Kluzak

Technology Director

North Dakota Public Service Commission

600 E Boulevard Ave

Dept 408 13^th Floor

Bismarck, ND  58505-0480

Phone: 701-328-4075


------------------------------------------------------------------------
This transmission, email and any files transmitted with it, may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential under federal or state law. If you are not the intended recipient of this message, you may not use, disclose, print, copy or disseminate this information. If you have received this transmission in error, notify the sender (only) and delete the message. This message may also be subject to disclosure under the North Dakota Open Records Laws.



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux