Symptom
Adding a retrieval argument to an existing DataWindow causes a "Column 2 has an invalid name and/or length " error. In addition, every other argument on the DataWindow's retrieval list is blanked out
Environment
-
Microsoft Windows 7
-
PowerBuilder
-
ActiveIdentity service
Reproducing the Issue
These are the steps to reproduce the issue:
-
Create a new DataWindow on a Windows 7 machine where the ActiveIdentity service is running.
-
Select a table and some columns.
-
Select Design/Retrieval Arguments.
-
Add 1 retrieval argument and then click the 'Add' command button again.
-
Try to add another retrieval argument and click OK and you should see the error: "Column 2 has an invalid name and/or length "
Cause
The cause of the error was determined to be the ActiveIdentity service.
Solution
Disabling the program or service solves the problem.
You can also work around the problem by adding the arguments manually if you are unable to determine which service is causing the problem.
To manually add arguments do the following:
1. Create a DataWindow with a single argument.
2 Close the DataWindow painter, right click on it in the treeview and select Edit Source.
3. Search for arguments in the source code.
4. Add arguments and save the file.
5. Open the DataWindow in the DataWindow painter and open the SQL view in order to associate the second argument with a field in the DataWindow.
