В таком случае, перенесите пожалуйста топик в пожелания.
Спасибо!
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts Menuselect
N.SNMP_OID,N.UNAME
from netxms.nodes N
left JOIN netxms.interfaces I on I.NODE_ID = N.id
and N.PRIMARY_IP = I.IP_ADDR
where I.IP_ADDR is null;
Target: INSERT INTO dc_tables (node_id,template_id,template_item_id,name,description,flags,source,snmp_port,polling_interval,retention_time,status,system_tag,resource_id,proxy_node,perftab_settings,transformation_script,comments,item_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Alert: ORA-00947: not enough values
Upgrading database...
Upgrading from version 318 to 319
Upgrading from version 319 to 320
Upgrading from version 320 to 321
Upgrading from version 321 to 322
SQL query failed (ORA-01440: column to be modified must be empty to decrease precision or scale):
ALTER TABLE users MODIFY system_access number(20)
Rolling back last stage due to upgrade errors...
Database upgrade failed
truncate table users
$ nxdbmgr upgrade
NetXMS Database Manager Version 1.2.15 Build 7881
Upgrading database...
Upgrading from version 321 to 322
SQL query failed (ORA-01440: column to be modified must be empty to decrease precision or scale):
ALTER TABLE user_groups MODIFY system_access number(20)
Rolling back last stage due to upgrade errors...
Database upgrade failed