Hi team
I am having a challenge on restoring a postres dump which is large (16gig),
it gives an error on restoring data in table analytics 2014.
Can anyone please help with how I can go around it, or maybe how to edit the
dump (notepad++ cannot open the file is too large).
Regards
Easiest way is to not dump the analytics tables at all. They can be
regenerated by running the analytics process once you have restores your
database without these tables.
Regards,
Jason
On Mar 11, 2015 5:31 PM, Ngoni Manika nman...@hotmail.com wrote:
Hi team
I am having a challenge on
Thanks a lot, I have also tried the command line but it's the same result. I
guess its corrupted then. Will try to do another one.
Thanks guys
Ngonidzashe Manika
Data Officer
+263 772 789673, nman...@hotmail.com mailto:nman...@hotmail.com , skype:
ngoni.manika
Ministry of Health and
Thanks Bob
Below is the error im getting
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 5328; 0 1415587 TABLE DATA
analytics_2014 postgres
pg_restore: [archiver (db)] COPY failed for table analytics_2014: ERROR:
missing data for
Thats a bit odd. If the data was in the table when it was dumped it should
be there when its restored. Looks like the dump file could be corrupted.
Are you restoring with pgadmin. You might have better luck with command
line.
If you don't have the option to make another dump then leave out these
Knut and Jason are both right. There is no point dumping tables which can
be recreated.
But that in itself shouldn't cause an error restoring a dump and 16G is far
from huge (of course too big for notepad++ but that's a different issue).
What was the error message?
On 11 March 2015 at 16:39,
This advice may be a bit late for you, but I would recommend excluding
analytics when you do a backup.
On 11 Mar 2015 17:31, Ngoni Manika nman...@hotmail.com wrote:
Hi team
I am having a challenge on restoring a postres dump which is large
(16gig), it gives an error on restoring data in
Hi Joao
Have you tried running the analytics to see if this will solve your problem?
Apps-Reports-Analytics and Data Mart
Nick
On Mar 11, 2015 7:22 PM, Joao Mazuze joao_maz...@chasssmt.com wrote:
Dear all,
We are facing now is about indicators, all the data entered manually
appear to be
Dear all,
We are facing now is about indicators, all the data entered manually appear to
be zero values on pivot tables when using indicators, we don´t know what is
happening as data elements produce real values. The only data visible using
indicators is the imported one from the old system we
Have you executed Analytics and DataMart for new data entered?
2015-03-11 9:22 GMT+01:00 Joao Mazuze joao_maz...@chasssmt.com:
Dear all,
We are facing now is about indicators, all the data entered manually
appear to be zero values on pivot tables when using indicators, we don´t
know what
Okay thanks.
On Wed, Mar 11, 2015 at 10:11 AM, Joao Mazuze joao_maz...@chasssmt.com
wrote:
Hi Lars,
I am able to create dataelements that make up my indicator expressions. I
will ask for access with my host provider in order to back up my database
and share it.
The attached *jpeg* file
Hi Joao,
we will need more information from you in order to help. Are you allowed to
share your database privately?
In pivot table, can you create a report with the data elements that make up
your indicator expressions? That could tell you whether the problem is with
the indicators or something
Hi all,
how DHIS2 system identify individual track in Aggregate Query Builder
when we choose Number of tracked entity instances?
THank you
CHANNARA
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Hi Lars,
I am able to create dataelements that make up my indicator expressions. I will
ask for access with my host provider in order to back up my database and share
it.
The attached jpeg file is an example showing indicator and the corresponding
dataElement that made it up, in period where
We have set Analytics and DataMarts to run automatically and we had also run
manually, but indicators still zero values. I would like to know if there is
any rule on indicators definitions like for instance, some characters are not
allowed or some other rules that have not been applied just to
Dear all,
Can someone please help me on a script doing the following:
I have a form with data Elements that must be filled with values according to
values entered in another data elements before submitting the form. How do I
get values from this data Elements/Indicators on the form in order to
Dear all,
Has anyone explain me more detail what is the different between DHIS2's
individual records vs OpenMRS? when we use both?
Thank you
CHANNARA
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
17 matches
Mail list logo