I have a pipeline that I am working on that requires data to be extracted and transformed in SQL Server (completed) and should be loaded into a single excel file. I cant seem to get my data into an excel file.
Has anyone completed a similar load, if so, how? What snaps and order did you use?
In my research I have seen a lot of articles about excel to DB but not the other way around.
@johnbilay, try adding your service account user to the VM local machine Administrators group, to see if that helps. We’ve been running JCC as a Windows service for 5+ years, and never had trouble running as an AD user, but that user has always been in the local machine Administrators group from the beginning.
As a side note: it’s extremely rare, but occasionally, we have had to reinstall the service for no apparent reason. You always have to reset the login user when you do this.
Aside from those thoughts, the most common issue we’ve had with the service not starting is that Java did an auto update and changed the Java path. So, I installed Java in at a non-standard path, turned off auto-updates in the Java console, and added the Java path to the jcc.bat file.
set JAVA_HOME="d:\opt\java"
I hope one of the ideas helps…
