Migrating P6 to P7: Mismatching data types when updating an Auto-Complete Control with ClipboardPage as Data Source
Hello,
we recntly migrated to P7 (or in the process of migrating...)
The problem we're facing now is with some controls that are not being updated automatically.
In one of the sections we used an Auto-Complete field with a ClipboardPage as a data source that needs to be updated (Figure 1)
when I click on "Update Controls" automatically it shows the following
but when we try and open the Declare_SICCodeList it throws the following error
fail The property TempOpenPage.pyLoadActivityParameters.pyDPConnectorResParam was of mode Java Object while com.pega.pegarules.data.internal.clipboard.ClipboardPropertyImpl.getStringValue() was expecting String mode.
and won't let us open the Declare Page.
this is a screenshot of how it used to be in P6
are we doing something wrong? We followed the article "Upgrading deprecated and outdated controls" but it didn't solve the problem.
Do we need to create a new Declare Page for P7?
thanks for you time
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Allianz Global Corporate & Specialty
US
thanks Patra for your response but I was able to determine the root cause which was a SQL error when the query is executed to select the records to populate the Data Page.
Allianz Global Corporate & Specialty
US
Turns out the SQL error wasn't the issue. I'm still not being able to open that Declare Page or open it in P7
Here is a screenshot of the ruleform
Also when I open the Clipboard I found two errors in the Data Pages' Nodes
D_PDNFeed (Code-Pega-List)
Caught unhandled exception: com.pega.apache.http.conn.HttpHostConnectException: Connection to https://collaborate.pega.com/ refused
Declare_EWF_SICCodeList
The specified SQL is invalid: Encountered "<EOF>" at line 0, column 0.
Was expecting one of:
"{" ...
"/*" ...
"\\{" ...
"\\}" ...
"\\\\" ...
<ANY> ...
I tried commenting out the Sql query or writing a simpler one but I keep getting the same error
Allianz Global Corporate & Specialty
US
I got rid of the error on the Data Page by coping the SQL statment in my ConnectSQL rule from the 'Browse' tab to the 'Open' tab (that;s a relief!) But I'm still getting an error on the PDNFeed data Page saying
"Caught unhandled exception: com.pega.apache.http.conn.HttpHostConnectException: Connection to https://collaborate.pega.com/ refused"
I googled the error and found a few suggestion to set the 'AllowAccessToExternalSystem' in the Dynamic System Setting to false but that didn't fix the error. I'm still not able to see the results in the Auto-Complete field.
Any help would be greatly appreciated