on 04-25-2016 4:38 PM
Hi all,
I am experiencing some troubles while attempting to connect to a PostgreSQL 8.4 DB through Data Manager.
I am running PA 2.5 on Windows 10 and using the ODBC PostgreSQL driver 9.5 (PAM documentation states to use 9.X driver).
Details of the error :
- If I go to Data Manager > Create a Data Manipulation and click on the Magnifier: it works as expected (I can view a sample from the targeted table).
- Then I click next > (fields of the table are correctly detected) > Views (tab) > Data and Statistics > refresh: an ODBC error [42703] is raised saying that the (first) column of my Table does not exist... but it is!
I got the same issue as soon as I want to save my Data Manipulation in a Table or a View.
What it is very curious is that if I decide to do an "Automated Analysis" like a Time Series Analysis, onto the orignal Table, the data is retrieved perfectly!
Do you guys have any suggestion? I actually have to do some data manipulation before running the analysis...
Thanks.
R.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry for the late reply.
Please find enclosed logs and screenshots.
Thanks !
Romain
And logs are available at: https://dl.dropboxusercontent.com/u/20779512/KxSupportFiles%20.zip
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.