Saturday 25 February 2012

Subaccountsfield links not created for------- Error in Non BO SubOffices



One day I got a call from one Sub office. Which dont have a branch office. They tell that while viewing the daily account an error occurs. It shows sub account field links has not created for that day. This error occurs mostly in offices which do not have a Branch office. The particular sub accounts field links table for that day is not created is the problem. In this situation most of system administrators firstly go to table open sub treasury table and rename the previous sub account field links table to today’s table. This procedure was not proper. When you do this there is a chance for repeating the error. A simple SQL query can solve this problem. The query is shown below.
Use Subtreasury
select *into subacfieldlinkstodaysdate from subacfieldlinkspreviousdate


If Any one want this  solution/Query  Please mail to me ---saparavur@gmail.com




When we have  this problem occurs in more than days. Then the following will solver the problem


Use Subtreasury

Drop table subacfieldlinks281111 ---The problem dates
select *into subacfieldlinks281111 from subacfieldlinks221111--The date in which daily account is properly taken

Drop table subacfieldlinks291111 
select *into subacfieldlinks291111 from subacfieldlinks221111

Drop table subacfieldlinks301111 
select *into subacfieldlinks301111 from subacfieldlinks221111



Note: Before doing any database operations. Please take the backup of the database

1 comments:

Admin on 25 February 2012 at 12:12 said...

Sir,
One Request. DOnt Post this type of SQL queries in the Blog. It will create problems. Pl send this thro email only...

M.RAJENDAN

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Sample text


Advertisement

 

Copyright 2008 All Rights Reserved saparavur theme by SA PARAVURr Converted into Blogger Template by SA PARAVUR