Hi Appian folks,
I am getting this error on Export SQL to Excel smart service - "The following error was raised by the Export SQL to Excel function: Name is insufficiently unique".
I have configured "Document_name_to_create" on this node by appending now() after the document name i.e. "Document Name " & now().
I understand that this error comes up when document name is not unique, although I have appended now() in the end, the error doesn't seem to resolve. How do I fix this issue?
Discussion posts and replies are publicly visible
Try with this for generating the value and test again please.
a!localVariables( local!data: split(tostring(rand()), "."), tointeger(local!data[2]))
Tried this logic too. Saved it in process variable and appended it in "Document_name_to_create" attribute as "Doc name " & pv!docName.
Didn't work. Same error.
Honstely by now I think we've ruled out the filename itself being the cause of this error.
Any chance you could try out the equivalent smart service either from the main Excel Tools plug-in, or from the newer stand-alone "SQL to Excel" plug-in (assuming this isn't the one you're already using), and see if the same issue happens?
"Document Name " & now() & "_" & milli()
Try using this.
Are you sure that you are using that name when generating the document? Maybe you are using a different variable?
Hi Ashwini,
Can you check again if all the columns of your SQL and Excel headers are unique? Also, if you are using cell_keys, check that as well.
Found the root cause here. The document name in a constant that was fetched by Copy Document Service node and the one fetched in Edit Document Properties node in case the document already exists - the document name is the same in both cases. That is why this error comes up on Export SQL to Excel node.
So this was the data issue.