Accept random events if you want to live with IT!

In my last article , I had detailed Aicha's consutling invoice layout requirements. From there, I had written a tutorial and made it available to the community on the adempiere wiki.

This document is not complete yet. Do you know why?

Because suddently, after asking some help on the community's forum, I got back to my Adempiere instance and just realised my Postgres service was not working anymore !!

I thought that Postgres and I became friends ! We spent all these hours playing together, joking together and now it decided to let me down. Maybe some command I typed felt like insulting to it! Who knows!

I spent a few hours searching on the the Internet and I read the error Postgres sent back (postgres service does not answer on localhost port 5432) is due to fact that there has been a Windows refresh of the Windows account running Postgres.

Apparently, this is known of Postgres & XP installations. No real solution to recover, we have to reinstall it all. Don't panic, this only happens occasionally apparently for Postgres 8.1 on XP versions.

So, I decided to reinstall Postgres on another windows 2003 server.

From there, I will continue to apply what has been recommanded in here and hopefully complete the Invoice Layout as requested by Mr Fahem. Thanks to reactive Mark & Colin from the forum, I could understand that Adempiere allows to embed a "print format" inside another "print format". The invoice layout is to Adempiere is nothing but a report with a header, a content and a footer.

The content, which details invoice line details can then be designed in another "print format".

We underestand that if we want to add a field "project code", "start date", "end date" in the invoice line of the layout, we will have to go in the "invoice line" print format and add elements in there.

So, I will get an Adempiere instance up & running in a new server and will continue the tutorial.

If I had just started the IT business, I would've turned crazy as of why did Postgres let me down with no justification and just like that. It had blown all my planning and reduced my sleep time.

However, after these years in the IT, I became comprehensive with machines and software.

They have the right for betrayal, they have the right for moaning. The only thing you can do is make sure you don't depend on their humours by backing up systems, mirror important things, ...etc.