Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (6)

Resolved Column 2 has an invalid name and/or length

  1. Issue
0
Votes
Undo
  1. Dayakar Beeravolu
    Dayakar Beeravolu
  2. PowerBuilder
  3. Wednesday, 7 December 2022 17:50 PM UTC

I have legacy  PowerBuilder 12.5 on sybase 15 , converting application  to Oracle database, while creating or accessing data window getting error "Column 2 has an invalid name and/or length" how to get around this error. This application is very small but used in day-to-day operations. Whenever I add 2nd retrieval argument I am getting this error

MICROSOFT SQL DRIVER NOT INSTALLED DURING DEPLOYME...
How to Check SQL in DataWindow During Full Build u...
Responses (6)
Dayakar Beeravolu
Dayakar Beeravolu Accepted Answer Pending Moderation
  1. Thursday, 8 December 2022 18:33 PM UTC
  2. PowerBuilder
  3. # 1

I am using Wimndow 10 OS and Oracle open client 12. It will not second argument and i get the error whenever I try to add second argument.

 

Attachments (1)
Retrieval arguments datawindow screen.zip
Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 8 December 2022 20:41 PM UTC
Please read all the comments and answers. It's a "bug". Windows 10 did not exist at the time of pb 12.5.
  1. Helpful
There are no comments made yet.
Ronnie Po
Ronnie Po Accepted Answer Pending Moderation
  1. Thursday, 8 December 2022 17:48 PM UTC
  2. PowerBuilder
  3. # 2

I used to encounter this error periodically. It occurred in Windows 7 as well as Windows 10. It wasn't just the second argument, but every even-numbered argument that would show up blank in the DW painter. Strangely, I came to the conclusion that it was somehow related to the video driver(s), since the only way to get rid of the issue was to disable certain drivers. I don't remember any other details, other than the computer was a tablet laptop with pen features, and unfortunately I no longer have that laptop. Chris Pollach might have more insight into this issue...

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 7 December 2022 21:16 PM UTC
  2. PowerBuilder
  3. # 3

This is a known bug in the PB v12.5 IDE.

Sadly, the only fix of which I am aware is to create a new DW. None of the other usual tricks work.

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 8 December 2022 05:35 AM UTC
As I already said in another comment and Olan has confirmed. It's a bug on windows 10. The only way to add more than one argument is by editing the source code.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 8 December 2022 05:35 AM UTC
(or work on windows 7 for your development)
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 8 December 2022 20:46 PM UTC
Just an idea: When I was suffering this bug, I installed Windows 7 on a virtual machine connected to source control. That virtual machine I would only use it to change dw arguments. For the rest of development everything worked fine on Windows 10.
  1. Helpful
There are no comments made yet.
Dayakar Beeravolu
Dayakar Beeravolu Accepted Answer Pending Moderation
  1. Wednesday, 7 December 2022 19:00 PM UTC
  2. PowerBuilder
  3. # 4

I have added using edit source, but when I go to retrieval arguments  second argument is missing and if i click ok i get same error. Using edit soruce it is saving the information but run time i get error .

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 7 December 2022 20:35 PM UTC
I don't see anything attached. I do seem to remember that some time ago there was a bug of not being able to add any retrieval arguments other than by editing the source code. What I don't remember is which version of PB that was...
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 8 December 2022 05:33 AM UTC
Ah okay now I remember. It was pb 12.6 on windows 10.
  1. Helpful
There are no comments made yet.
Kevin Ridley
Kevin Ridley Accepted Answer Pending Moderation
  1. Wednesday, 7 December 2022 18:06 PM UTC
  2. PowerBuilder
  3. # 5

https://docs.appeon.com/pb2022/troubleshooting_guide/tr_018.html

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 7 December 2022 18:05 PM UTC
  2. PowerBuilder
  3. # 6

Hi,

If you export your datawindow and your definitions of the used tables and attach the information in a zip file, we might be able to check if anything is off.

Also, which client database driver are you using and what is your connection profile for SQLCA?

regards.

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.