Items are not added in records

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

Items are not added in records

Prawesh Shrestha
The items are not added in record. It is not displayed in any view - MARC, ITEM and others. But when items are searched for barcode printing, they are displayed without the features to add to the label. The check box and 'Add' don't appear. If 'Edit Items' is clicked the items are there. I checked the database, no items are written in 'Item' table. i tried the following command:

sudo -u koha perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -v -w

it output the following:

.
.
.
.
13:40:47-03/03 zebraidx(3905) [log] Records: 57000 i/u/d 10/56990/0
13:40:53-03/03 zebraidx(3905) [log] Records: 58000 i/u/d 19/57981/0
13:40:58-03/03 zebraidx(3905) [log] Records: 59000 i/u/d 28/58972/0
13:41:11-03/03 zebraidx(3905) [log] Merge 14.0% completed; 61 seconds remaining
13:41:21-03/03 zebraidx(3905) [log] Merge 40.3% completed; 29 seconds remaining
13:41:31-03/03 zebraidx(3905) [log] Merge 57.6% completed; 22 seconds remaining
13:41:41-03/03 zebraidx(3905) [log] Merge 59.6% completed; 27 seconds remaining
13:41:51-03/03 zebraidx(3905) [log] Merge 70.0% completed; 21 seconds remaining
13:42:01-03/03 zebraidx(3905) [log] Merge 76.0% completed; 18 seconds remaining
13:42:11-03/03 zebraidx(3905) [log] Merge 81.4% completed; 16 seconds remaining
13:42:21-03/03 zebraidx(3905) [log] Merge 87.3% completed; 11 seconds remaining
13:42:27-03/03 zebraidx(3905) [fatal] Bad block size -8 in pos=511075

zebraidx: isamb.c:549: open_block: Assertion `p->size >= 0' failed.
====================
CLEANING
====================

I checked for any changes in settings found no changes at all.

Need your help.

With regards,
--
Prawesh Shrestha
Project Engineer
---------------------------------------------
Young Innovations Pvt. Ltd.
GPO 8976 EPC 241
Pulchowk, Lalitpur, Nepal
Tel: +977-01 5009282

http://yipl.com.np
info[at]yipl[dot]com[dot]np
----------------------------------------------------


_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: [Koha-devel] Items are not added in records

nitesh rijal
Hello.

How did you managed to import the record is the main thing.

Did you add all the items while importing the MARC? What was the message when you imported the records???

items are stored in items table and as well as in the marcxml field in the biblioitem table.

please put the message that showed while importing records to koha.

regards.

2011/3/3 Prawesh Shrestha <[hidden email]>
The items are not added in record. It is not displayed in any view - MARC, ITEM and others. But when items are searched for barcode printing, they are displayed without the features to add to the label. The check box and 'Add' don't appear. If 'Edit Items' is clicked the items are there. I checked the database, no items are written in 'Item' table. i tried the following command:

sudo -u koha perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -v -w

it output the following:

.
.
.
.
13:40:47-03/03 zebraidx(3905) [log] Records: 57000 i/u/d 10/56990/0
13:40:53-03/03 zebraidx(3905) [log] Records: 58000 i/u/d 19/57981/0
13:40:58-03/03 zebraidx(3905) [log] Records: 59000 i/u/d 28/58972/0
13:41:11-03/03 zebraidx(3905) [log] Merge 14.0% completed; 61 seconds remaining
13:41:21-03/03 zebraidx(3905) [log] Merge 40.3% completed; 29 seconds remaining
13:41:31-03/03 zebraidx(3905) [log] Merge 57.6% completed; 22 seconds remaining
13:41:41-03/03 zebraidx(3905) [log] Merge 59.6% completed; 27 seconds remaining
13:41:51-03/03 zebraidx(3905) [log] Merge 70.0% completed; 21 seconds remaining
13:42:01-03/03 zebraidx(3905) [log] Merge 76.0% completed; 18 seconds remaining
13:42:11-03/03 zebraidx(3905) [log] Merge 81.4% completed; 16 seconds remaining
13:42:21-03/03 zebraidx(3905) [log] Merge 87.3% completed; 11 seconds remaining
13:42:27-03/03 zebraidx(3905) [fatal] Bad block size -8 in pos=511075

zebraidx: isamb.c:549: open_block: Assertion `p->size >= 0' failed.
====================
CLEANING
====================

I checked for any changes in settings found no changes at all.

Need your help.

With regards,
--
Prawesh Shrestha
Project Engineer
---------------------------------------------
Young Innovations Pvt. Ltd.
GPO 8976 EPC 241
Pulchowk, Lalitpur, Nepal
Tel: +977-01 5009282

http://yipl.com.np
info[at]yipl[dot]com[dot]np
----------------------------------------------------


_______________________________________________
Koha-devel mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/



--
Er. Nitesh Rijal
rijal.it@gmail.com
http://niteshrijal.com.np
http://facebook.com/openrijal
http://twitter.com/open_zilla
+9779841458173

_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: [Koha-devel] Items are not added in records

Prawesh Shrestha
Its not about importing records. Its about creating new records and adding new items to it while cataloging. And it is not working. 

--
Prawesh Shrestha
Project Engineer
---------------------------------------------
Young Innovations Pvt. Ltd.
GPO 8976 EPC 241
Pulchowk, Lalitpur, Nepal
Tel: +977-01 5009282

http://yipl.com.np
info[at]yipl[dot]com[dot]np
----------------------------------------------------


_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: [Koha-devel] Items are not added in records

nitesh rijal
oh sorry, I didn't understand that.
which version are you using? what os?

On Thu, Mar 3, 2011 at 5:14 PM, Prawesh Shrestha <[hidden email]> wrote:
Its not about importing records. Its about creating new records and adding new items to it while cataloging. And it is not working. 


--
Prawesh Shrestha
Project Engineer
---------------------------------------------
Young Innovations Pvt. Ltd.
GPO 8976 EPC 241
Pulchowk, Lalitpur, Nepal
Tel: +977-01 5009282

http://yipl.com.np
info[at]yipl[dot]com[dot]np
----------------------------------------------------




--
Er. Nitesh Rijal
rijal.it@gmail.com
http://niteshrijal.com.np
http://facebook.com/openrijal
http://twitter.com/open_zilla
+9779841458173

_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: [Koha-devel] Items are not added in records

Prawesh Shrestha
Version: 3.00.05.003
OS: Ubuntu Server

It was working before and now its not.

with regards,
-- 
Prawesh Shrestha
Project Engineer
---------------------------------------------
Young Innovations Pvt. Ltd.
GPO 8976 EPC 241
Pulchowk, Lalitpur, Nepal
Tel: +977-01 5009282

http://yipl.com.np
info[at]yipl[dot]com[dot]np
----------------------------------------------------


_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: [Koha-devel] Items are not added in records

Prawesh Shrestha
In reply to this post by nitesh rijal
the items that are entered in new records and the old ones are automatically "on hold". Is that what causing the problem i am facing?



--
Prawesh Shrestha
Project Engineer
---------------------------------------------
Young Innovations Pvt. Ltd.
GPO 8976 EPC 241
Pulchowk, Lalitpur, Nepal
Tel: +977-01 5009282

http://yipl.com.np
info[at]yipl[dot]com[dot]np
----------------------------------------------------


_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: [Koha-devel] Items are not added in records

hansbkk
>> 2011/3/3 Prawesh Shrestha <[hidden email]>:
> I am really confused with your reply. Is it really meant for me? My problem is that I can not find new item entry under new record or the old ones. It doesn't exit but can be viewed while editing items.

Yes, I meant exactly what I wrote - I'm afraid I can't help you, and I
doubt if anyone can, unless you give much more specific information.
For example, is this a relatively new install, or a system that is
currently in production? Have you already entered in large amounts of
data or have you just started? Are you manually entering in data or
trying to import it from outside the system? Are you looking at the
data from the staff interface or the OPAC? Search results or detail
screen? Have you tried looking at the data in the MySQL tables
directly, and can you see a difference between the records that are
showing and the ones that are not?

2011/3/4 Prawesh Shrestha <[hidden email]>:
> the items that are entered in new records and the old ones are automatically "on hold". Is that what causing the problem i am facing?


Do you mean that in the sames sense as a staff member "placing a hold"
on a resource for a patron? Or do you mean something else?


>> > It was working before and now its not.

> <[hidden email]> wrote:
>> Yes but we need more detail in order to try to help you: ideally a step-by-step process that would allow someone else to see the same results.
>> Otherwise the only advice would be export your data (if it's valuable to you), wipe everything, re-install and then import it back.
>> Personally I recommend constructing all your biblio-level data "master" records outside of Koha as MARC files, and importing them all at once.
>> This makes it easy to not only ensure consistency between records, but also let's you easily start over with a new Koha instance, have a test instance vs your production one, etc.
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: [Koha-devel] Items are not added in records

mason@kohaaloha
Administrator
In reply to this post by nitesh rijal

On 2011-03-3, at 11:30 PM, Nitesh Rijal wrote:

> Hello.
>
> How did you managed to import the record is the main thing.
>
> Did you add all the items while importing the MARC? What was the message when you imported the records???
>
> items are stored in items table and as well as in the marcxml field in the biblioitem table.
>
> please put the message that showed while importing records to koha.
>
> regards.
>
> 2011/3/3 Prawesh Shrestha <[hidden email]>
> The items are not added in record. It is not displayed in any view - MARC, ITEM and others. But when items are searched for barcode printing, they are displayed without the features to add to the label. The check box and 'Add' don't appear. If 'Edit Items' is clicked the items are there. I checked the database, no items are written in 'Item' table. i tried the following command:
>
> sudo -u koha perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -v -w
>
> it output the following:
>
> .
> .
> .
> .
> 13:40:47-03/03 zebraidx(3905) [log] Records: 57000 i/u/d 10/56990/0
> 13:40:53-03/03 zebraidx(3905) [log] Records: 58000 i/u/d 19/57981/0
> 13:40:58-03/03 zebraidx(3905) [log] Records: 59000 i/u/d 28/58972/0
> 13:41:11-03/03 zebraidx(3905) [log] Merge 14.0% completed; 61 seconds remaining
> 13:41:21-03/03 zebraidx(3905) [log] Merge 40.3% completed; 29 seconds remaining
> 13:41:31-03/03 zebraidx(3905) [log] Merge 57.6% completed; 22 seconds remaining
> 13:41:41-03/03 zebraidx(3905) [log] Merge 59.6% completed; 27 seconds remaining
> 13:41:51-03/03 zebraidx(3905) [log] Merge 70.0% completed; 21 seconds remaining
> 13:42:01-03/03 zebraidx(3905) [log] Merge 76.0% completed; 18 seconds remaining
> 13:42:11-03/03 zebraidx(3905) [log] Merge 81.4% completed; 16 seconds remaining
> 13:42:21-03/03 zebraidx(3905) [log] Merge 87.3% completed; 11 seconds remaining
> 13:42:27-03/03 zebraidx(3905) [fatal] Bad block size -8 in pos=511075
>
> zebraidx: isamb.c:549: open_block: Assertion `p->size >= 0' failed. <<<<<<<< OOPS!!!!!!


the reason your zebra rebuild is failing, could be you are running out of space in your /tmp directory?

this has happened to me recently...


cheers, Mason
--
KohaAloha, NZ

_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
moo
Reply | Threaded
Open this post in threaded view
|

Re: [Koha-devel] Items are not added in records

mason@kohaaloha
Administrator

On 2011-03-6, at 1:12 PM, James, Mason wrote:

>>
>> 2011/3/3 Prawesh Shrestha <[hidden email]>
>> The items are not added in record. It is not displayed in any view - MARC, ITEM and others. But when items are searched for barcode printing, they are displayed without the features to add to the label. The check box and 'Add' don't appear. If 'Edit Items' is clicked the items are there. I checked the database, no items are written in 'Item' table. i tried the following command:
>>
>> sudo -u koha perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -v -w
>>
>> it output the following:
>> .
>> .
>> 13:40:47-03/03 zebraidx(3905) [log] Records: 57000 i/u/d 10/56990/0
>> 13:40:53-03/03 zebraidx(3905) [log] Records: 58000 i/u/d 19/57981/0
>> 13:40:58-03/03 zebraidx(3905) [log] Records: 59000 i/u/d 28/58972/0
>> 13:41:11-03/03 zebraidx(3905) [log] Merge 14.0% completed; 61 seconds remaining
>> 13:41:21-03/03 zebraidx(3905) [log] Merge 40.3% completed; 29 seconds remaining
>> 13:41:31-03/03 zebraidx(3905) [log] Merge 57.6% completed; 22 seconds remaining
>> 13:41:41-03/03 zebraidx(3905) [log] Merge 59.6% completed; 27 seconds remaining
>> 13:41:51-03/03 zebraidx(3905) [log] Merge 70.0% completed; 21 seconds remaining
>> 13:42:01-03/03 zebraidx(3905) [log] Merge 76.0% completed; 18 seconds remaining
>> 13:42:11-03/03 zebraidx(3905) [log] Merge 81.4% completed; 16 seconds remaining
>> 13:42:21-03/03 zebraidx(3905) [log] Merge 87.3% completed; 11 seconds remaining
>> 13:42:27-03/03 zebraidx(3905) [fatal] Bad block size -8 in pos=511075
>>
>> zebraidx: isamb.c:549: open_block: Assertion `p->size >= 0' failed. <<<<<<<< OOPS!!!!!!
>
>
> the reason your zebra rebuild is failing, could be you are running out of space in your /tmp directory?
>
> this has happened to me recently...


also, have you modified you zebra config files?

perhaps that is your problem?


cheers, Mason
--
KohaAloha, NZ

_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
moo
Reply | Threaded
Open this post in threaded view
|

Re: [Koha-devel] Items are not added in records

Prawesh Shrestha
Thank you all for your precious advice. But I think I was not clear enough to put up problems i am facing. I will try to elaborate it.


Server information
Koha version: 3.00.05.003
OS version ('uname -a'): Linux anachronic 2.6.35-27-generic #48-Ubuntu SMP Tue Feb 22 20:25:46 UTC 2011 x86_64 GNU/Linux
Perl interpreter: /usr/bin/perl
Perl version: 5.010001
Perl @INC: /usr/share/koha/lib 
/etc/perl 
/usr/local/lib/perl/5.10.1 
/usr/local/share/perl/5.10.1 
/usr/lib/perl5 
/usr/share/perl5 
/usr/lib/perl/5.10 
/usr/share/perl/5.10 
/usr/local/lib/site_perl 

MySQL version: mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline 6.1
Apache version: Server version: Apache/2.2.16 (Ubuntu)
Zebra version: Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU

After installation and configurations done, lots of data were imported from ISIS. Everything was working perfectly - cataloging, circulation, acquisition, barcode and patron card printing. But now, the problem I am facing is that when I add new items in existing records or new records, the items are not shown in any view in staff interface page. But the items are visible if items are edited in records. This time, when items are edited, the barcode entered earlier to the item disappears in editing page. In database too, there are no entry of new items in items table. I thought if building index will solve the problem but to my dismay it didn't work as the indexing process failed. 

while printing barcode, the new items are visible in return to search. However, the facility to add the item in new label batch is not available. For old items, its still working. 

I hope it will clear my problems to you and you will be able to help me solve the problem.


With Regards,
--
Prawesh Shrestha
Project Engineer
---------------------------------------------
Young Innovations Pvt. Ltd.
GPO 8976 EPC 241
Pulchowk, Lalitpur, Nepal
Tel: +977-01 5009282

http://yipl.com.np
info[at]yipl[dot]com[dot]np
----------------------------------------------------


_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha