Guest

Preview Tool

Cisco Bug: CSCvu66844 - Extracting image type on SQL server activity.

Last Modified

Jun 18, 2020

Products (1)

  • Cisco Process Orchestrator

Known Affected Releases

3.5.1

Description (partial)

Symptom:
Customer is trying to extract some image data from a sql server database.
He is  using a select activity, but when he is looking into the  output cpo return to my some values as 0x:0x:0x:0x.
 
He tried to cast this image type into var binary and then into var chart but still have the  problem making this convert on cpo, if he is running the sql query in SQL Query browser it  works without any problem.
The activity show as fail but the activity of sql show as running and i could not stop, only by restarting cpo.

Below is the Exact Use case mention by Customer:

What we are trying to do is extract the data of a pdf from a field of a table, and then create the file and upload it into a file share.
The problem that we are facing is related to extract the information from the table using the activity of sql.
When i´m trying to perform this query on sql I don´t have any problem, but when I try to do it by cpo it give different information.
What I understand is that cpo is trying to get an string as an output, because of the definition of the datatype on the properties of the activity,  so that why make the conversion and give weir charactarters.
 
I try to perform a conversion so cpo can get that varchar but it give an error in the conversion.
Also I have a problem regarding this activites because they remain in a running state, that when I try to kill it i doesn’t do it, I attach also an image of what error give me.
 
I attach to you some image that are the runs that I perfom in sql and then the runs on cpo to make this difference.

Conditions:
After Upgrade CPO 3.5.1.98 with  patch 12
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.