Not able to see the generated DDL/Schema file from BIX Extract in the output directory
We are implementing BIX in our organization to extract some properties in CSV to our application server. We specified the path and tested the connectivity. It is good. When we run the extract, it is showing a success message and few records are extracted as well, but we are not able to see the extracted sql/manifest file in the local directory. I appreciate your help.
I'm a little confused about what output format you are using. Are you extracting to CSV or DB? If you are extracting to CSV then the extracted file will be on the app server in the directory specified if running from the UI or if running from the command line it will be on the node you are running from. For a DB extract then obviously the output would be in the target DB. If you are generating the DDL then again will depend on if you are running from UI or command line on what node it will be on. If you post the PegaBIX log file the details should all be in there.
I am extracting to CSV and not able to find it on the app server. Then I tried with DDL generation, even I didn't find the sql file in the app server. And I am running the extract from Designer studio not the command line.
For your extract rule could you post a screenshot of the "File Specification" tab. For a csv extraction there is no DDL. That is only for a DB extraction. Are you generating a manifest and sending that to the database or have you just tried with csv and with db separately and just don't see the output file?
Is the \\nasgwss0021pn.uhn.com your app server node? If you run with just \pas\PASdev\BIX do you see the output in that directory? It isn't throwing an error that it cannot write to that output so it seems like it is writing it somewhere. What specific version of Pega/BIX 7.1 is this?
You are saying it is your node but is it the node where the application server is actually running? It seems like it is not the actual app server node as when you try to write to that directory it is telling you there isn't a directory /pas/PASdev/BIX
So you are saying that even though on the screenshot it says creating schema file to "\\nasgwss0021pn.uhc.com\pas\PASdev\BIX.sql", there is no file called BIX.sql present? And there are no errors in BIX log file?
Also, DDL (schema) generation is not required if your extract type is CSV.