Integer Picklists on Openedge Service Objects

What happens when you create a new record? Can you save picklist's value successfully?

Hi,

When I create a new record and choose "strongest", then the underlying openEdge record has the correct value of 4 assigned, but it is never  displayed properly within Rollbase.

Thanks

Could you check OpenEdge communication log file? Link (button) can be found on Object View page.

This is the output from all my recent reads:

[2015-05-29 17:13:13,978] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting

[2015-05-29 17:13:14,853] Customer Settings: Response: Chars: 494, a132: 1

[2015-05-29 17:13:18,605] Customer Settings: Filter: CustomerSettingId=1

[2015-05-29 17:13:18,606] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting?filter=CustomerSettingId%3D1

[2015-05-29 17:13:19,473] Customer Settings: Response: Chars: 494, a132: 1

[2015-05-29 17:13:19,494] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting

[2015-05-29 17:13:20,356] Customer Settings: Response: Chars: 494, a132: 1

[2015-05-29 17:14:42,152] User Account: Filter: {"ablFilter":"(LoginName<>'') AND (LoginName<>?)"}

[2015-05-29 17:14:42,153] http://localhost:8810/hrpo/rest/hrpoService/siPerson?filter=%7B%22ablFilter%22%3A%22%28LoginName%3C%3E%27%27%29+AND+%28LoginName%3C%3E%3F%29%22%7D

[2015-05-29 17:14:53,203] User Account: Filter: {"ablFilter":"(LoginName<>'') AND (LoginName<>?)"}

[2015-05-29 17:14:53,204] http://localhost:8810/hrpo/rest/hrpoService/siPerson?filter=%7B%22ablFilter%22%3A%22%28LoginName%3C%3E%27%27%29+AND+%28LoginName%3C%3E%3F%29%22%7D

[2015-05-29 17:14:57,515] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting

[2015-05-29 17:14:57,610] Customer Settings: Response: Chars: 494, a132: 1

[2015-05-29 17:15:01,987] Customer Settings: Filter: CustomerSettingId=1

[2015-05-29 17:15:01,988] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting?filter=CustomerSettingId%3D1

[2015-05-29 17:15:02,100] Customer Settings: Response: Chars: 494, a132: 1

[2015-05-29 17:15:02,119] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting

[2015-05-29 17:15:02,220] Customer Settings: Response: Chars: 494, a132: 1

[2015-05-29 17:15:04,358] User Account: Response: Chars: 11375, a132: 13

[2015-05-29 17:15:21,738] Customer Settings: Filter: CustomerSettingId=1

[2015-05-29 17:15:21,739] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting?filter=CustomerSettingId%3D1

[2015-05-29 17:15:22,606] Customer Settings: Response: Chars: 494, a132: 1

[2015-05-29 17:15:49,451] Customer Settings: Filter: CustomerSettingId=1

[2015-05-29 17:15:49,452] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting?filter=CustomerSettingId%3D1

[2015-05-29 17:15:50,324] Customer Settings: Response: Chars: 494, a132: 1

[2015-05-29 17:15:50,343] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting

[2015-05-29 17:15:51,217] Customer Settings: Response: Chars: 494, a132: 1

However, there  was an error raised when doing my initial create:

[2015-05-29 17:00:53,835] Communication error:{"_errors":[{"_errorMsg":"ERROR condition: Framework Error: 1002,Unable to instantiate class com.sage.hrpo.be.beCustomerTenant.,, (SG20) (7211)","_errorNum":20}]}

I'll correct that problem and see if it helps, although I'm not sure it would explain why the existing records aren't displaying correctly.

Let me check the problem

I cannot reproduce the problem: Picklist (int) field can be displayed and updated without problems.

Please check log generated when record is updated. You should see something like this:

[2015-05-29 11:09:49,737] Update ttItem: request

{"dsItem":{"ttItem":[{"Special": "1", "Category2": "Equipment", "OnOrder": 479, "Itemnum": 7, "Weight": 8.00, "Category1": "Diving", "Price": 125.00, "ItemName": "Buoyancy Vest", "CatDescription": "Stay afloat with your own helium buoyancy vest.", "seq": 1, "Minqty": 30, "Allocated": 10876, "Onhand": 12877, "ReOrder": 15, "CatPage": 6}]}}

[2015-05-29 11:09:50,231] Update ttItem: response

{"dsItem":{"ttItem":[{"Allocated":10876,"CatDescription":"Stay afloat with your own helium buoyancy vest.","Category1":"Diving","Category2":"Equipment","CatPage":6,"ItemName":"Buoyancy Vest","Itemnum":7,"Minqty":30,"Onhand":12877,"OnOrder":479,"Price":125.0,"ReOrder":15,"Special":"1","Weight":8.0,"id":"","seq":1}]}}

Please note value for "CatPage" field which was set to 6 in my test. On View/edit page I see option "Six".

Also, when you expand picklist field, do you see all choices beneath "Please select" prompt? Just to make sure that your configuration was saved successfully.

Finally, it always helpful to know whether problem remains after Rollbase server restart.

There was an issue with retrieving integer and displaying pick-list with OpenEdge Service Objects. This is fixed in main branch (4.0 release). Tentative time-frame for 4.0 release is August.

Hello,

What is the defect number for this issue for tracking purposes?

Thank you,
Gian