I want to answer based on compose-mysql database but don’t know how to do..

I connected compose-mysql and application.
After npm start at localhost:3000, and I checked if I say “table create” and the bot response “table create success” and the table create query I coded node.js really performed and I can check this result on my local mysql. And insert data too.

But, I wonder that if I ask to bot “I want to see my data” then how to make the bot to say the result corresponding my database??
Plz help me..

Related:

oraoci9 suddenly inserts only blank columns from sequential stage

Hi there,
I had an already functioning serverjob, which imports data from a csv file to an oracle staging table.
After being delivered a new csv file, I first had some trouble with NLS, an extension by 2 columns, etc. which I managed to fix. Now the job is running ok, 0 rows being rejected, ALL rows go to the table, but when I watch the result in oracle I have ALL but the columns which are not targeted by the job, but have a default value are
EMPTY !!. A record count of the table (Job is set to truncate before insert) shows 148200 rows !
My DS is Version 8.1

![alt text][1]

[1]: /answers/storage/temp/18833-ds-oracle-table.jpg

Related:

Cast Iron Update Rows Activity

Hello

I have an orchestration that’s successfully inserting/updating oracle table.
Two new columns are added in the table.
Both fields are varchar(1), nullable=true.
I tried refreshing the columns in CI, set default values for the columns in update rows activity.

I could see the values in rows(input) in webconsole run, however The update rows gives following error-

“An exception occurred while processing a SingleTableNotification job. Data error at row number 0 of table . The Error is null”

What could i be missing? Please suggest.

Related:

Samsung SAFE ELM License Key fails to deploy with error Invalid ELM Key or ELM Key Corrupted

Proceed as follows in order to confirm that your server is displaying the symptoms of this specific problem.

Firstly, generate and collect a Support Bundle from XenMobile Server.

Then locate the file that is named ‘variables.xml’ within the Support Bundle.

Take note of the ELM License Key value that is found inside of this file.

Next, run the following SQL command on the SQL database server for XenMobile Server:

SELECT * FROM EWPROPERTY WHERE NAME = ‘elm.license.key’

Note that this particular database query may or may not return a result.

Only if a result is returned from the database by this query and the value returned is different to the value of the ELM License Key as found within ‘variables.xml’, then your server does have the symptoms of this specific problem.

To clarify:

If a result is not returned from the database by this query, then your server does not have the symptoms of this specific problem. Instead, there may be a different cause of the problem, which still needs to be identified.

Similarly, if a result is returned from the database by this query and the value returned is identical to the value of the ELM License Key within ‘variables.xml’, then your server does not have the symptoms of this specific problem.

If you have confirmed that your server is indeed displaying symptoms of this specific problem, then proceed through the following instructions:

As a best practice, backup the SQL database itself (or the entire database server) before making the following change.

Run the following SQL command on the SQL database server for XenMobile Server:

DELETE FROM EWPROPERTY WHERE NAME = ‘elm.license.key’

The command listed above will remove the offending entry from the underlying database.

As such, XenMobile Server 10.7 will begin to use the correct key, as stored in ‘variables.xml’, when trying to resolve the macro ‘${elm.license.key}’.

Related:

Bug in db2? Count(*) not behaving correctly after alter table

Hi everyone, I noticed that count(*) is giving 0 for dangling tuples in a query with a group by, when it should give 1. This is happening only in some situations, in particular after an alter table where I define a foreign key. Here is a sample code to show what I mean:

CREATE TABLE TABLE_1
( X INT NOT NULL PRIMARY KEY);
CREATE TABLE TABLE_2
( Y INT NOT NULL );
INSERT INTO TABLE_1
VALUES (1),
(2),
(3),
(4),
(5);
INSERT INTO TABLE_2
VALUES (1),
(1),
(2);
If I now do this query:

SELECT T1.X, COUNT (*) as c1
from TABLE_1 T1 left join TABLE_2 T2 on (T1.X = T2.Y)
group by T1.X;
I get the expected result with at least 1 for every row.
But the result set changes after this after table followed by a runstats:

ALTER TABLE TABLE_2
ADD CONSTRAINT fk FOREIGN KEY (Y) REFERENCES TABLE_1 ;
RUNSTATS ON TABLE TABLE_1;
Now the same query gives me 0 in c1 for the dangling tuples which it’s not correct.

UPDATE:

I noticed that the same problem happens when I do the following: create the tables, insert some values, define the foreign key WITHOUT executing runstats, executing

REORG TABLE TABLE_1;
REORG TABLE TABLE_2;
And execute the query written above with the select count(*). This bring to the same WRONG result set with some zeros for dangling tuples.

BUT it’s even more weird that if I execute the query at least once before executing REORG TABLE, the problem doesn’t show up (neither in the query before REORG nor in the result of the query after REORG) and the result set is the correct one. It seems like the first query changes the behaviour of REORG TABLE.

An user on stackoverflow, where I posted this [question][1], suggested me to ask here to get some more information.

I would like to know if you guys also think that this is a bug or if I’m making a mistake somewhere.

NOTE: this is happening on a v9.7 server, using both v9.7 and v11.1 clients (clients running on windows 10 64bit, while the server is the university’s one, running on Linux 64bit).

[1]: https://stackoverflow.com/questions/47268933/select-count-not-behaving-correctly-after-alter-table?noredirect=1

Related:

Datacap SmartSQL ORA00942 Error

Hi all, I am having some issues with my smartSQL statement on datacap. This is the statement that will cause me to have the following error:

– *Query* –
**select LISTAGG(column1, ‘|’) within group (order by columnID) column2 from (select column1, columnID from tableName where column3 in (‘value1’, ‘value2’, ‘value3’, ‘value4′) and column4=’value’ and column1 is not null)**

– *Database Error* –
**ConnErrHandler
Description: ORA-00942: table or view does not exist**

When I use the Oracle SQL Developer, my query works and the same database credentials are used on both the SQL developer and Datacap. A simple insert statement for the same database table works via the datacap’s smartSQL rule. From what I understand, the error occurs when there are not enough rights to perform a certain action, however I have checked that the rights was given to that particular set of credentials. I am not sure on what the issue is, and how to solve it. I would appreciate some help on this thank you. Let me know if you need more information

Related:

JDBC Gateway to DB2 fails to insert some records with SQLCODE=-803, SQLSTATE=23505

The gateway is able to insert some records but others fail.

The following SQL error codes occur in the log file:

Error: E-GJA-000-000: [ngjava]: G_JDBC: pool-1-thread-18: SQL State is null
Error: E-GJA-000-000: [ngjava]: G_JDBC: pool-1-thread-18: SQL Error code: -4229
Debug: D-GJA-000-000: [ngjava]: G_JDBC: pool-1-thread-18: SQL State: 23505
Debug: D-GJA-000-000: [ngjava]: G_JDBC: pool-1-thread-18: SQL Error code: -803
Error: E-GJA-000-000: [ngjava]: G_JDBC: pool-1-thread-18: SQL State is null
Error: E-GJA-000-000: [ngjava]: G_JDBC: pool-1-thread-18: SQL Error code: -4229
Debug: D-GJA-000-000: [ngjava]: G_JDBC: pool-1-thread-18: SQL State: 23505
Debug: D-GJA-000-000: [ngjava]: G_JDBC: pool-1-thread-18: SQL Error code: -803

What could be causing this and what is the best way to troubleshoot it?

Related: