Help, can not create new Topic

More
1 month 1 day ago - 1 month 1 day ago #26189 by admin
We had a a look at the source code we were not able to find any changes related to date format

The format is defined by NLS_DATE_FORMAT parameter.

you can check it by execution the following sql

SELECT VALUE FROM NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_DATE_FORMAT';

There are multiple way to set date format  for example we can force it in inside our software by executing 
Code:
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';

Immediately after login

Or you can set environment variable to NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS

Please try setting environment variable and let us know if it helps or not

Mike
ETL Architect
Last edit: 1 month 1 day ago by admin.

Please Log in or Create an account to join the conversation.

More
1 month 1 day ago #26190 by Peter.Jonson
I have tested setting environment variable to NLS_DATE_FORMAT and it did not work.

I have sent you email to a special build please install it and let us know the outcome.

Please also email us a screenshot of the about box 

 

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
1 month 1 day ago #26191 by dudleybokf20
Downloaded and installed, checking now...
Yep, seeing Date and time now in source data grid.
Will do more testing on other tables and report back shortly..

Please Log in or Create an account to join the conversation.

More
1 month 1 day ago #26192 by dudleybokf20
Installed on Prod App server, had a kafka.dll error in use, but skipped it.
VI services were off so not sure what was source of lock.
Post install requiring a reboot, need to find window in next 2 hours in between production jobs to pause and reboot then test more from the app server.

Please Log in or Create an account to join the conversation.

More
1 month 1 day ago - 1 month 1 day ago #26193 by dudleybokf20
Hit new error running first Oracle table import...
adsCheckEnabled: Field 'ENABLED_EXECUTION' not found.
What repository table needs that column added?

See snip of error message and snip of tables that do have ENABLE_EXECUTION column
VIADMIN is schema i use for PC.
VIADMIN3 is schema i use for App server.

Added full schema scripts of existing objects
Attachments:
Last edit: 1 month 1 day ago by dudleybokf20. Reason: added .txt of existing schema meta

Please Log in or Create an account to join the conversation.

More
1 month 23 hours ago #26194 by dudleybokf20
Pulled the repository creation script and only three tables with ENABLED_EXECUTION column listed.
I have all three of them already in my Oracle repository.

CREATE TABLE SCHEDULE (
ENABLE_EXECUTION NUMBER (1) default 0 NOT NULL ,

CREATE TABLE EVENT_MONITORS (
ENABLE_EXECUTION NUMBER(1,0) DEFAULT 0 NOT NULL ,

CREATE TABLE NODE_STATUS (
ENABLE_EXECUTION NUMBER(1,0) DEFAULT 0 NOT NULL,

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save