Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
sms_error_-_index_out_of_date [2019/03/28 17:43]
smerritt 		sms_error_-_index_out_of_date [2019/06/13 19:37] (current)
smerritt [Explanation of Error]
Line 75: Line 75:
  
 - Run a dbrebuild scan on the table(s) to see if it needs to be rebuilt. If so, rebuild it - Launch SSLIP and SMS - confirm that the error no longer appears - Run a dbrebuild scan on the table(s) to see if it needs to be rebuilt. If so, rebuild it - Launch SSLIP and SMS - confirm that the error no longer appears
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 1</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Adjustments Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Adjustments Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 2</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Contact Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Contact Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 3</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Customer Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Customer Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 4</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Estimate Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Estimate Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 5</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Estimate Details Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Estimate Details Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 6</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Estimate Modifiers Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Estimate Modifiers Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 7</font>**
 +
 +<code sql>
 +
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\GL Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\GL Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 8</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Order Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 9</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Order Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 10</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Details Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Order Details Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 11</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Modifiers Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Order Modifiers Database"
 +</code>
 +
 +**<font 16px/inherit;;inherit;;inherit>SQL 12</font>**
 +
 +<code sql>
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Modifiers Database"
 +SELECT *
 +FROM "\\server\Cyrious$\SMS\Data\Order Modifiers Database"
 +</code>
 +</code>
 +