177603 - no subject - I am facing 500 internal server code whi

madhubindug over 9 years ago

I am facing 500 internal server code while trying to export report data into excel. Am using ExportableDataSubset, export to excel plugin - getdatasubsetdownloadlinkfromrule function.
First I have been pulling the data based on the report filters and then need to modify the datasubset for pulling few other details based on the values retrieved, so I have used updatecdt function. Below is what I found before and after modifying the datasubsets which be might causing the issue, for modified datasubset, identifiers are different:

First datasuset: [startIndex=1, batchSize=-1, sort=[field=createdDate, ascending=false], totalCount=3, data=[id:6637,requestId:536930204,mainCategory:Anti-Money Laundering,serviceRequestType:Enhanced Due Diligence,workflowStatus:Pending With AML,accountNumber:A98765432,createdDate:10/21/2015 6:48 AM PDT,lastModifiedUser:riyazfa,createdBy:riyaz,requestClosedDate:,signature:,boUser:]; [id:6622,requestId:536930052,mainCategory:Anti-Mone...

code.txt

Discussion posts and replies are publicly visible

0 madhubindug over 9 years ago

...y Laundering,serviceRequestType:Enhanced Due Diligence,workflowStatus:Pending with FA,accountNumber:A98765432,createdDate:10/21/2015 4:45 AM PDT,lastModifiedUser:riyaz,createdBy:riyazfa,requestClosedDate:,signature:,boUser:]; [id:6597,requestId:55683,mainCategory:Anti-Money Laundering,serviceRequestType:Enhanced Due Diligence,workflowStatus:Pending with FA,accountNumber:A98765432,createdDate:10/19/2015 7:44 AM PDT,lastModifiedUser:riyazfa,createdBy:riyaz,requestClosedDate:,signature:,boUser:], identifiers=6637; 6622; 6597]

Modified Datasubset: [startIndex=1, batchSize=-1, sort=[field=createdDate, ascending=false], totalCount=3, data=[id:6637,requestId:536930204,mainCategory:Anti-Money Laundering,serviceRequestType:Enhanced Due Diligence,workflowStatus:Pending With AML,accountNumber:A98765432,createdDate:10/21/2015 6:48 AM PDT,lastModifiedUser:riyazfa,createdBy:riyaz,requestClosedDate:,signature:priyafa,boUser:1]; [id:6622,requestId:536930052,mainCategory:Anti-Money...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 madhubindug over 9 years ago

... Laundering,serviceRequestType:Enhanced Due Diligence,workflowStatus:Pending with FA,accountNumber:A98765432,createdDate:10/21/2015 4:45 AM PDT,lastModifiedUser:riyaz,createdBy:riyazfa,requestClosedDate:,signature:riyaz,boUser:1]; [id:6597,requestId:55683,mainCategory:Anti-Money Laundering,serviceRequestType:Enhanced Due Diligence,workflowStatus:Pending with FA,accountNumber:A98765432,createdDate:10/19/2015 7:44 AM PDT,lastModifiedUser:riyazfa,createdBy:riyaz,requestClosedDate:,signature:priyafa,boUser:1], identifiers=1; 2; 3]

Please find attached code for your reference.

Thanks,
Madhu
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ravi Roshan over 7 years ago

Did you get the solution for this, I am getting the same error. However my data store entity is returning the result and my exportable rule is also returning the result. Process model is working fine. Please suggest the solution for this.
Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aswinb608
A Score Level 2
over 6 years ago

Please ensure that you are passing a datasubset to ExportableDataSubset rather than datasubset.data
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Arpit Bhargava over 6 years ago

Can you please check the field names what you are using to fetch from the datasubset?
If the field names are not correct according to the cdt then it will through an 500 internal server as well.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ravi Roshan over 6 years ago in reply to aswinb608

Yes, This was the issue. I have identified later. Thanks :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel